PC SOFT

AYUDA EN LÍNEA
DE WINDEV, WEBDEV Y WINDEV MOBILE


  • Order of items
  • Displaying the result in a List Box or Combo Box control
  • HFSQL type
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Otros
Procedimientos almacenados
HListItem (Function)
 
ODBCNo disponible con este tipo de conexión
Returns the list of items:
  • found in a data file ( a query or a view) known to the HFSQL engine. The data files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
  • Versiones 19 y posteriores
    WINDEVWEBDEV - Código ServidorWindows Mobile found in a Record variable.
    Nueva funcionalidad versión 19
    WINDEVWEBDEV - Código ServidorWindows Mobile found in a Record variable.
    WINDEVWEBDEV - Código ServidorWindows Mobile found in a Record variable.
Versiones 15 y posteriores
Android This function is now available for Android applications.
Nueva funcionalidad versión 15
Android This function is now available for Android applications.
Android This function is now available for Android applications.
Versiones 17 y posteriores
iPhone/iPad This function is now available for iPhone/iPad applications.
Nueva funcionalidad versión 17
iPhone/iPad This function is now available for iPhone/iPad applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Versiones 18 y posteriores
Widget Android This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Procedimientos almacenados This function is now available in the code of stored procedures.
Nueva funcionalidad versión 18
Widget Android This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Procedimientos almacenados This function is now available in the code of stored procedures.
Widget Android This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Procedimientos almacenados This function is now available in the code of stored procedures.
Versiones 21 y posteriores
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Nueva funcionalidad versión 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.
señalar: A partir de la versión 19, HFSQL es el nuevo nombre de HyperFileSQL.
Ejemplo
// Retrieve the items of a file from the current analysis
ItemList is string
ItemList = HListItem(CUSTOMER, hLstDétail)

// 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
Sintaxis

Listing the items of a data file Ocultar los detalles

<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
Java In Java, <Caption> corresponds to the name of item.
<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.
Java This parameter is ignored. 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 ("").
Java This parameter is ignored.
<Options>: Optional Integer constant (or combination of constants)
Configures the type of list to perform:
hLstNormal
(default value)
Corresponds to hLstItem + hLstMemo + hLstKey
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 earlier versions).
hLstDetailPlusFor the numeric items, adds the number of digits in the integer part and in the decimal part.
Hyper File 5.5 This constant is ignored.
hLstMemoLists the memo items
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.
hLstItemLists the non-key and non-memo items
hLstOriginalItemUsed 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.
Hyper File 5.5 This constant is ignored.

Java This constant is not available.
hLstAllLists all the type of items (hLstItem + hLstMemo + hLstKey + hLstCompositeKey)
Hyper File 5.5 This constant is ignored.
hLstSortedSorts the list in alphabetical order
Hyper File 5.5 This constant is ignored.
Versiones 19 y posteriores
WINDEVWEBDEV - Código ServidorWindows Mobile

Listing the items of a Record variable Ocultar los detalles

<Result> = HListItem(<Record> [, <Options>])
<Result>: Character string
List of items found in the specified Record variable . 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
<Record>: Record variable
Name of Record variable from which the list of items will be retrieved.
<Options>: Optional Integer constant (or combination of constants)
Configures the type of list to perform:
hLstNormal
(default value)
Corresponds to hLstItem + hLstMemo + hLstKey
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 earlier versions).
hLstDetailPlusFor the numeric items, adds the number of digits in the integer part and in the decimal part.
Hyper File 5.5 This constant is ignored.
hLstMemoLists the memo items
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.
hLstItemLists the non-key and non-memo items
hLstOriginalItemUsed 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.
Hyper File 5.5 This constant is ignored.
hLstAllLists all the type of items (hLstItem + hLstMemo + hLstKey + hLstCompositeKey).
Hyper File 5.5 This constant is ignored.
hLstSortedSorts the list in alphabetical order.
Hyper File 5.5 This constant is ignored.
Nueva funcionalidad versión 19
WINDEVWEBDEV - Código ServidorWindows Mobile

Listing the items of a Record variable Ocultar los detalles

<Result> = HListItem(<Record> [, <Options>])
<Result>: Character string
List of items found in the specified Record variable . 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
<Record>: Record variable
Name of Record variable from which the list of items will be retrieved.
<Options>: Optional Integer constant (or combination of constants)
Configures the type of list to perform:
hLstNormal
(default value)
Corresponds to hLstItem + hLstMemo + hLstKey
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 earlier versions).
hLstDetailPlusFor the numeric items, adds the number of digits in the integer part and in the decimal part.
Hyper File 5.5 This constant is ignored.
hLstMemoLists the memo items
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.
hLstItemLists the non-key and non-memo items
hLstOriginalItemUsed 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.
Hyper File 5.5 This constant is ignored.
hLstAllLists all the type of items (hLstItem + hLstMemo + hLstKey + hLstCompositeKey).
Hyper File 5.5 This constant is ignored.
hLstSortedSorts the list in alphabetical order.
Hyper File 5.5 This constant is ignored.
WINDEVWEBDEV - Código ServidorWindows Mobile

Listing the items of a Record variable Ocultar los detalles

<Result> = HListItem(<Record> [, <Options>])
<Result>: Character string
List of items found in the specified Record variable . 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
<Record>: Record variable
Name of Record variable from which the list of items will be retrieved.
<Options>: Optional Integer constant (or combination of constants)
Configures the type of list to perform:
hLstNormal
(default value)
Corresponds to hLstItem + hLstMemo + hLstKey
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 earlier versions).
hLstDetailPlusFor the numeric items, adds the number of digits in the integer part and in the decimal part.
Hyper File 5.5 This constant is ignored.
hLstMemoLists the memo items
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.
hLstItemLists the non-key and non-memo items
hLstOriginalItemUsed 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.
Hyper File 5.5 This constant is ignored.
hLstAllLists all the type of items (hLstItem + hLstMemo + hLstKey + hLstCompositeKey).
Hyper File 5.5 This constant is ignored.
hLstSortedSorts the list in alphabetical order.
Hyper File 5.5 This constant is ignored.
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:
0unknown type1automatic identifier on 8 bytes
2text item3signed integer item on 2 bytes
4signed integer item on 1 byte5signed integer item on 4 bytes
6simple real item (on 4 bytes)7simple real item (on 8 bytes)
8record number item (unsigned integer)9unsigned integer item on 2 bytes
10date item on 611time item
12unsigned integer item on 1 byte13turbo real item
14date item on 815text memo item
16binary memo 4.0 item17currency item
18binary memo, image memo item,
Sound memo, OLE memo or other binary memo
19signed integer item on 8 bytes
20unsigned integer item on 8 bytes21image item
22unsigned integer item on 4 bytes23character string item
24date+time item25duration item
26character item27boolean item
28automatic identifier item (on 4 bytes)29Unicode text item
30Unicode text memo item31high-precision numeric item
32
Versiones 20 y posteriores
Enumeration item
Nueva funcionalidad versión 20
Enumeration item
Enumeration item
33
Versiones 20 y posteriores
Combination item
Nueva funcionalidad versión 20
Combination item
Combination item
34
Versiones 24 y posteriores
128-bit UUID item
Nueva funcionalidad versión 24
128-bit UUID item
128-bit UUID item
35
Versiones 24 y posteriores
128-bit automatic UUID item
Nueva funcionalidad versión 24
128-bit automatic UUID item
128-bit automatic UUID item
36
Versiones 24 y posteriores
256-bit UUID item
Nueva funcionalidad versión 24
256-bit UUID item
256-bit UUID item
37
Versiones 24 y posteriores
256-bit automatic UUID item
Nueva funcionalidad versión 24
256-bit automatic UUID item
256-bit automatic UUID item
Componente : wd240hf.dll
Versión mínima requerida
  • Versión 9
Esta página también está disponible para…
Comentarios
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
BOLLER
25 06 2018