PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Displaying the result in a list box or in a combo box
  • Extracting an information from the result
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Returns the list of keys found in a data file (query or view) recognized by the HFSQL engine. You can find out:
  • the type of key,
  • its size,
  • whether the key is unique or with duplicates, ...
The files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
Android Widget This function is now available in Android Widget mode.
Java This function is now available for the Java applications.
Android This function is now available for the Android applications.
New in version 22
Android Widget This function is now available in Android Widget mode.
Java This function is now available for the Java applications.
Android This function is now available for the Android applications.
Android Widget This function is now available in Android Widget mode.
Java This function is now available for the Java applications.
Android This function is now available for the Android applications.
// Retrieve the keys of a file found in the current analysis
KeyList is string
KeyList = HListKey(CUSTOMER, hLstDetail)
// Adds the list of keys into COMBO_COMBO1
ListAdd(COMBO_COMBO1, KeyList)
Syntax
<Result> = HListKey(<File Name> [, <Path of WDD> [, <Password of WDD> [, <Options>]]])
<Result>: Character string
List of items found in the specified data file. The different descriptions of each key are separated by CR characters (Carriage Return). The listed keys are sorted according to the physical order of the keys in the data file (except if the hLstSorted constant is used).
The result is more or less detailed depending on the constant used:
hLstDetail is not specified<Name of Key 1> + CR + <Name of Key 2 + CR + ...
The result is identical with hLstKey and/or hLstCompositeKey and/or hLstSorted.
hLstDetail is specified<Name of Key 1> + TAB + <Type> + TAB+ <Size> + TAB + <Expression> + TAB + <Unique> + TAB + <Caption> + CR +...
hLstDetailPlus<Name of Key 1> + TAB + <Type> + TAB + <Size> + TAB + <Expression> + TAB + <Unique> + TAB + <Caption> + TAB + <Integer Part of Numeric Keys> + TAB + <Decimal Part of Numeric Keys> + CR +...
Where:
  • <Name of Key X>: name of the key
  • <Type>: type of key: "T" for text (and currency) or "N" for numeric
  • <Size>: item size
  • <Expression>: expression of the key for a composite key (for a simple key, only the key name is returned)
  • <Unique>: "1" for a unique key, "0" for a key with duplicates
  • <Caption>: caption of the key
  • <Integer Part of Numeric Keys>: number of digits in the integer part of numeric keys
  • <Decimal Part of Numeric Keys>: number of digits in the decimal part of numeric keys
<File Name>: Character string (with or without quotes)
Name of data file (query or view) whose keys will be listed.
If a query name is specified, this query must be currently run (HExecuteQuery or HExecuteSQLQuery) in order for HListKey to operate. Otherwise, a WLanguage error occurs.
<Path of WDD>: Optional character string (with quotes)
Full path of the analysis (which means .WDD file) in which the data file is described.
If this parameter is not specified or if it is equal to an empty string (""), the data file is sought in the current analysis.
<Password of WDD>: Optional character string (with quotes)
Password defined for the analysis.
If no password is defined, this parameter must be equal to an empty string ("").
<Options>: Optional Integer constant (or combination of constants)
Configures the type of list to perform:
hLstNormal
(default value)
Corresponds to hLstAll. Value used by default if the hLstKey, hLstCompositeKey and hLstAll constants are not used.
hLstKeyLists the key items (non-composite keys only).
Hyper File 5.5 This constant is ignored.
hLstCompositeKeyLists the composite key items only.
Hyper File 5.5 This constant is ignored.
hLstDetailDetailed information (idem WINDEV 5.5).
hLstDetailPlusFor the numeric keys, add the number of digits found in the integer part and in the decimal part.
Hyper File 5.5 This constant is ignored.
hLstLogicalOrderSorts the list in logical order of items (ignored if hLstSorted is specified).
Hyper File 5.5 This constant is ignored.
hLstOriginalItemUsed on a log file (xxxJNL.fic), lists the keys of the initial source file (that was logged). For example, on CustomerJNL.Fic, list the key items of CUSTOMER file.
Hyper File 5.5 This constant is ignored.
hLstSortedSorts the list in ascending order.
Hyper File 5.5 This constant is ignored.
hLstAllLists all the keys (hLstKey + HLstCompositeKey).
Hyper File 5.5 This constant is ignored.
Remarks

Displaying the result in a list box or in a combo box

<Result> can be directly assigned to a list box or to a combo box by ListAdd. Each row will contain the name of one of the keys found.

Extracting an information from the result

To extract an information from the detailed result, we recommend that you use ExtractString.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment