|
|
|
|
|
|
|
|
- Displaying the result in a List Box or Combo Box control
- Extracting information from the result
<Fuente>.ListKey (Función)
 No disponible con este tipo de conexión
ListeCle is string
ListeCle = Client.ListeClé(hLstDetail)
COMBO_COMBO1.Ajoute(ListeCle)
Sintaxis
<Result> = <Source>.ListKey([<Path of the WDD file> [, <Password of the WDD file> [, <Options>]]])
<Result>: Cadena de caracteres 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>:
- "2" for primary keys.
- "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.
<Source>: Tipo de fuente especificada Name of data file (query or view) whose keys will be listed.If a query name is specified, this query must be currently run ( .ExecuteQuery or .ExecuteSQLQuery) in order for <Fuente>.ListKey to operate. Otherwise, a WLanguage error occurs. <Path of the WDD file>: Cadena de caracteres opcional 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 the WDD file>: Cadena de caracteres opcional Password defined for the analysis.
If no password is defined, this parameter must be equal to an empty string (""). <Options>: Constante o combinación de constantes de tipo Integer (opcional) Type of list to perform:
| | | hLstAll | Lists all the keys (hLstKey + hLstCompositeKey).
| | hLstCompositeKey | Lists the composite key items only.
| | hLstDetail | Detailed information (idem WINDEV 5.5). | | hLstDetailPlus | For the numeric keys, add the number of digits found in the integer part and in the decimal part.
| | hLstKey | Lists the key items (non-composite keys only).
| | hLstLogicalOrder | Sorts the list in logical order of items (ignored if hLstSorted is specified).
| hLstNormal
(default value) | Corresponds to hLstAll. Value used by default if the hLstKey, hLstCompositeKey and hLstAll constants are not used. | | hLstOriginalItem | Used 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.
| | hLstSorted | Sorts the list in ascending order.
|
Observaciones Displaying the result in a List Box or Combo Box control <Result> can be directly assigned to a List Box or Combo Box control by .add . Each row will contain the name of one of the keys found. Extracting information from the result
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|