PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Returns a list of keys to add to data files to improve query performance.
Example
sMyString is string
sMyString = HSuggestKey(MyConnection, ((MyQuery1, MyQuery2, MyQuery3))
Trace(sMyString)
Syntax
<Result> = HSuggestKey(<Connection> , <Queries>)
<Result>: Character string
Readable message for the developer, containing the list of keys to be added to the data files in order to optimize the queries.
<Connection>: Character string or Connection variable
Connection to the HFSQL server containing the queries to be analyzed. This connection corresponds to:
<Queries>: List of values enclosed in brackets and separated by commas
List of queries to be analyzed (10 queries maximum). This list of queries has the following format:
(<Query 1>, ..., <Query N>)
where:
  • <Query 1>: First query to be analyzed.
  • ...
  • <Query N>: Nth query to be analyzed.
Remark: It is possible to analyze queries created with the query editor, WLanguage queries or SQL queries. The different types of queries can be mixed in the list.
Remarks
  • The function takes a maximum of 10 queries as parameters. To accept more queries, it is recommended to use HSuggestKeyStart and HSuggestKeyEnd.
  • To analyze a query with a parameter, you must provide the value of the parameter before executing HSuggestKey. For example:
    MySELECT_PRODUCTqry is SQL Query =
    [
    SELECT * FROM PRODUCT
    WHERE PRODUCT.Reference = {pReference}
    ]
    MySELECT_PRODUCTqry.pReference = 123
    let sListKey = HSuggestKey(MyConnection, (MySELECT_PRODUCTqry))

    If no value is given for the query parameter(s), the query condition will not be taken into account. In that case, no keys will be suggested.
  • Keys are suggested according to the data contained in the data file. If a data file contains no data, no key will be suggested.
Business / UI classification: Business Logic
Component: wd270hf.dll
See also
Minimum version required
  • Version 26
This page is also available for…
Comments
Click [Add] to post a comment