- Order of items
- Displaying the result in a List Box or Combo Box control
- HFSQL type
HListItem (Function) In french: HListeRubrique
 Not available with this kind of connection
// Retrieve the items of a file from the current analysis
ItemList is string
ItemList = HListItem(CUSTOMER, hLstDetail)
// Add the list of items into COMBO_COMBO1
ListAdd(COMBO_COMBO1, ItemList)
// Run a "SELECT *" query and interrogate the items
dsListCITY is Data Source
sListItm is string
sRecContent is string
sQry is string = "SELECT * FROM ZIPCODES WHERE ZIPCODE ='34000'"
// Run the query
HExecuteSQLQuery(dsListCITY, hQueryDefault, sQry)
// List the items of the query.
sListItm = HListItem(dsListCITY)
// Browse the query
FOR EACH dsListCITY
sRecContent = ""
// The items must be browsed for each record
FOR EACH STRING sAnItem OF sListItm SEPARATED BY CR
sRecContent += {"dsListCITY." + sAnItem, indItem}
END
Info("Content of the record: " + sRecContent)
END
Syntax
Listing the items of a data file Hide the details
<Result> = HListItem(<File name> [, <Path of WDD> [, <Password of WDD> [, <Options>]]])
<Result>: Character string List of items found in the specified data file. The descriptions of each item are separated by CR characters (Carriage Return). 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 subscripts> + TAB + <Caption> + CR + ... | | hLstDetailPlus | <Name of item 1> + TAB + <Type> + TAB + <HFSQL type> + TAB + <Size> + TAB + <Number of subscripts> + TAB + <Caption> + TAB + <Integer part of numeric items> + TAB + <Decimal part of numeric items> + CR + ... |
Where:- <Name of item X>: Item name
- <Type>: Type of item: "T" for text (and currency) or "N" for numeric
- <HFSQL type>: HFSQL type of item. See Remarks for more details.
- <Size>: Item size
- <Number of subscripts>: Number of elements in the array
- <Caption>: Caption of item.
- <Integer part of numeric items>: Number of digits in the integer part of numeric items
- <Decimal part of numeric items>: Number of digits in the decimal part of numeric items
<File name>: Character string (with or without quotes) Name of data file (query or view) whose items will be listed.If a query name is specified, this query must be currently run ( HExecuteQuery or HExecuteSQLQuery) in order for HListItem to operate. Otherwise, a WLanguage error occurs. <Path of WDD>: Optional character string Full path of analysis (.WDD file) where 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 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 hLstItem + hLstMemo + hLstKey | | hLstKey | Lists the key items (non-composite keys only)
| | 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.
| | hLstMemo | Lists the memo items
| | hLstLogicalOrder | Sorts the list in logical order of items (ignored if hLstSorted is specified)
| | hLstItem | Lists the non-key and non-memo items | | 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.
| | hLstAll | Lists all the type of items (hLstItem + hLstMemo + hLstKey + hLstCompositeKey)
| | hLstSorted | Sorts the list in alphabetical order
|
 Versions 19 and later New in version 19Remarks 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. The possible HFSQL types are as follows: | | | | | 0 | unknown type | 1 | automatic identifier on 8 bytes | | 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 | Versions 20 and laterEnumeration item New in version 20Enumeration item Enumeration item | 33 | Versions 20 and laterCombination item New in version 20Combination item Combination item | | 34 | Versions 24 and later128-bit UUID item New in version 24128-bit UUID item 128-bit UUID item | 35 | Versions 24 and later128-bit automatic UUID item New in version 24128-bit automatic UUID item 128-bit automatic UUID item | | 36 | Versions 24 and later256-bit UUID item New in version 24256-bit UUID item 256-bit UUID item | 37 | Versions 24 and later256-bit automatic UUID item New in version 24256-bit automatic UUID item 256-bit automatic UUID item |
This page is also available for…
|
|
|
| |
| Example - Table with create column use HListItem |
|
| FiltraUsuarios("")
//AlteraNomeColunasQuery("TABLE_usuario","QRY_Select_All_Usuarios")
//usando a estrutura da query
sColuna is string = pTableNameControl+".COL_Column"
ItemList is string = HListItem( {pQueryName,indFile} , hLstDetail)
CountCampos is int = StringCount(ItemList,CRLF)
//c is int
//
//loop (CountCampos)
// c+=1
//
// //TableInsertColumn /// windev
//
//END
ItemList = Replace(ItemList,CRLF,";")
ItemList = Replace(ItemList,TAB,";")
x is int = 6
y is int = 0
VARTEXT is string
LOOP(CountCampos)
y+= 1
VARTEXT = ExtractString(ItemList,x,";",FromBeginning)
{sColuna+y,indControl}..Caption = VARTEXT
{sColuna+y,indControl}..Visible = True
x+= 6
END |
|
|
|
| |
| |
| |
| |
| |
| |
| | |
|