|
|
|
|
|
|
|
|
|
|
- Order of items
- Displaying the result in a List Box or Combo Box control
- HFSQL type
HListItem (Function)
 No disponible con este tipo de conexión
ItemList is string
ItemList = HListItem(Customer, hLstDetail)
ListAdd(COMBO_COMBO1, ItemList)
dsListCITY is Data Source
sListItm is string
sRecContent is string
sQry is string = "SELECT * FROM ZIPCODES WHERE ZIPCODE ='34000'"
HExecuteSQLQuery(dsListCITY, hQueryDefault, sQry)
sListItm = HListItem(dsListCITY)
FOR EACH dsListCITY
sRecContent = ""
FOR EACH STRING sAnItem OF sListItm SEPARATED BY CR
sContentEnreg += {"sdListeVILLE." + sUneRubrique, indVariable}
END
Info("Record content: " + sContenuEnreg)
END
Sintaxis
Listing the data file items Ocultar los detalles
<Result> = HListItem(<Data file> [, <Path of the WDD file> [, <Password of the WDD file> [, <Options>]]])
<Result>: Character string List of items found in the specified data file. The descriptions of each item are separated by carriage returns. The result is more or less detailed depending on the constant used: | | | hLstDetail is not specified | <Name of item 1> + CR + <Name of item 2> + CR + ... | | hLstDetail is specified | <Name of item 1> + TAB + <Type> + TAB + <HFSQL type> + TAB + <Size> + TAB + <Number of indexes> + TAB + <Caption> + CR + ... | | hLstDetailPlus | <Name of item 1> + TAB + <Type> + TAB + <HFSQL type> + TAB + <Size> + TAB + <Number of indexes> + TAB + <Caption> + TAB + <Integer part of numeric items> + TAB + <Decimal part of numeric items> + CR + ... |
Where:- <Nom de rubrique X> Item name
- <Type> Field type: "T" for text (and currency) or "N" for numeric
- <Type HFSQL> HFSQL type of the field. For more details, see Remarks.
- <Taille>: Section size
- <Number of indices>: Number of elements in the array
- <Libellé>: Name of heading.
- <Partie entière des rubriques numériques> Number of digits in the integer part of numeric fields
- <Partie décimale des rubriques numériques> Number of digits in the decimal part of numeric fields
<Data file>: Character string Name of the data file (query or view) whose items will be listed.If a query name is specified, the query must be running ( HExecuteQuery or HExecuteSQLQuery) to use HListItem. Otherwise, a WLanguage error occurs. <Path of the WDD file>: Optional character string Full path of analysis (.WDD file) where the data file is described. If this parameter is not specified or is an empty string (""), the data file is searched for in the current analysis.
<Password of the WDD file>: : Optional string or Secret string Password defined for the analysis. If no password is defined, this parameter must be an empty string ("").
 Novedad versión 2025Cadenas secretas: Si utiliza el almacén de cadenas secretas, el tipo de cadena secreta utilizado para este parámetro debe ser "ANSI o Unicode string". Para obtener más información sobre las cadenas secretas y el almacén, consulte Almacén de cadenas secretas.
Novedad versión 2025
<Options>: Optional Integer constant (or combination of constants) Type of list to perform: | | | hLstAll | Lists all the type of items (hLstItem + hLstMemo + hLstKey + hLstCompositeKey)
| | hLstCompositeKey | Lists the composite key items only
| | hLstDetail | Detailed information (idem earlier versions). | | hLstDetailPlus | For the numeric items, adds the number of digits in the integer part and in the decimal part.
| | hLstItem | Lists the non-key and non-memo items | | hLstKey | Lists the key items (non-composite keys only)
| | hLstLogicalOrder | Sorts the list in logical order of items (ignored if hLstSorted is specified)
| | hLstMemo | Lists the memo items
| hLstNormal
(default value) | Corresponds to hLstItem + hLstMemo + hLstKey | | hLstOriginalItem | Used on a log file (xxxJNL.fic), lists the items of the source file (that was logged). For example, on CustomerLOG.Fic, lists the items of CUSTOMER file.
| | hLstSorted | Sorts the list in alphabetical order
|
Observaciones Order of items The items listed in <Result> are sorted according to the physical order of items in the data file (except if the hLstSorted constant is used). 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 ListAdd. Each row will contain the description of an item. HFSQL type The possible HFSQL types are as follows: | | | | | 0 | unknown type | 1 | 8-byte automatic identifier | | 2 | text item | 3 | signed integer item on 2 bytes | | 4 | signed integer item on 1 byte | 5 | signed integer item on 4 bytes | | 6 | simple real item (on 4 bytes) | 7 | simple real item (on 8 bytes) | | 8 | record number item (unsigned integer) | 9 | unsigned integer item on 2 bytes | | 10 | date item on 6 | 11 | time item | | 12 | unsigned integer item on 1 byte | 13 | turbo real item | | 14 | date item on 8 | 15 | text memo item | | 16 | binary memo 4.0 item | 17 | currency item | | 18 | binary memo, image memo item,
Sound memo, OLE memo or other binary memo | 19 | signed integer item on 8 bytes | | 20 | unsigned integer item on 8 bytes | 21 | image item | | 22 | unsigned integer item on 4 bytes | 23 | character string item | | 24 | date+time item | 25 | duration item | | 26 | character item | 27 | boolean item | | 28 | automatic identifier item (on 4 bytes) | 29 | Unicode text item | | 30 | Unicode text memo item | 31 | high-precision numeric item | | 32 | Enumeration item | 33 | Combination item | | 34 | 128-bit UUID item | 35 | 128-bit automatic UUID item | | 36 | 256-bit UUID item | 37 | 256-bit automatic UUID item | | 38 | JSON item | 39 | Secure Password item |
Clasificación Lógica de negocio / UI: Lógica de negocio
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|