|
|
|
|
- Displaying the result in a List Box or Combo Box control
- HListFile function and the Native MySQL or MariaDB Connector
HListFile (Function) In french: HListeFichier
Not available with this kind of connection
Returns the list of data files: - found in the current analysis or in a specific analysis recognized by the HFSQL engine. The data files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
- available on a connection via a native access or via an OLE DB driver.
- for a group defined in the data model editor.
  The groups defined in the data model editor are not supported.
// Retrieve the data files described in the analysis and through programming FileList is string FileList = HListFile(hLstDétail + hLstAll) // Add the list of data files in COMBO_COMBO1 ListAdd(COMBO_COMBO1, FileList) // Display in a trace Trace(FileList)
Syntax
Listing the data files of an analysis Hide the details
<Result> = HListFile([<Path of the WDD file> [, <Password of the WDD file>]] [, <Options>])
<Result>: Character string List of data files found in the current analysis or in the specified analysis. The descriptions of each analysis are separated by a CR character (Carriage Return). The result is more or less detailed depending on the constant used: | | hLstDetail is not specified | <Name of data file 1> + CR + <Name of data file 2> + CR + ... | hLstDetail is specified | <Name of data file 1> + TAB + <Abbreviation> + TAB + <Caption> + TAB + <Physical name> + CR + ... |
Where:
- <Name of data file X>: Logical name of the data file (used in programming).
- <Abbreviation>: Abbreviation of data file.
- <Caption>: Caption of data file.
- <Physical name>: Physical name of data file (on disk).
<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 if it is equal to an empty string (""), the data file is sought in the current analysis. <Password of the WDD file>: 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) | List not sorted, not detailed, without the data files described by programming. | hLstDetail | Lists the detailed information (same as WINDEV 5.5). | hLstAll | Lists all the data files (including the ones described by HDeclare, HDeclareExternal and HDescribeFile).
| hLstSorted | Sorts the list of data files in ascending order.
|
Remarks 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 full name of one of the analyses found.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|