ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Example: Displaying the characteristics of a key in the trace
HListKey (Example)
Example: Displaying the characteristics of a key in the trace
WINDEVWEBDEV - Server codeReports and QueriesUser code (UMC)AjaxHFSQL ClassicHFSQL Client/ServerOLE DBNative Connectors (Native Accesses) This example is used to display all the characteristics of the key in a trace window. Each characteristic is extracted from the result of HListKey by ExtractString.
// Displays the characteristics of a key in the trace
sKeyList is string
 
sKeyList = HListKey(CUSTOMER, hLstDetail)
// Retrieves the first key
sKeyList = ExtractString(sKeyList, 1, CR)
// Displays the name of the key
Trace(ExtractString(sKeyList, 1))
// Displays the type of the key
Trace(ExtractString(sKeyList, 2))
// Displays the size of the key
Trace(ExtractString(sKeyList, 3))
// Displays the expression of the key
Trace(ExtractString(sKeyList, 4))
// Displays the uniqueness of the key
Trace(ExtractString(sKeyList, 5))
// Displays the caption of the key
Trace(ExtractString(sKeyList, 6))
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help