PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Displaying the result in a List Box or Combo Box control
  • HListFile function and the native MySQL or MariaDB access
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
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.
    AndroidAndroid Widget Java The groups defined in the data model editor are not supported.
Windows Mobile To optimize the size of the applications, the OLE DB drivers are not available in this version.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 19 and later
WEBDEV - Server codePHP This function is now available for the WEBDEV sites in PHP.
New in version 19
WEBDEV - Server codePHP This function is now available for the WEBDEV sites in PHP.
WEBDEV - Server codePHP This function is now available for the WEBDEV sites in PHP.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 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.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
Android Widget This function is now available in Android Widget mode.
WINDEVJava This function is now available for the Java applications.
Android This function is now available for the Android applications.
New in version 22
Android Widget This function is now available in Android Widget mode.
WINDEVJava This function is now available for the Java applications.
Android This function is now available for the Android applications.
Android Widget This function is now available in Android Widget mode.
WINDEVJava This function is now available for the Java applications.
Android This function is now available for the Android applications.
// Retrieves the files described in the analysis and by programming
FileList is string
FileList = HListFile(hLstDetail + hLstAll)

// Adds the list of files into COMBO_COMBO1
ListAdd(COMBO_COMBO1, FileList)

// Displays in a trace
Trace(FileList)
Syntax

Listing the analysis files Hide the details

<Result> = HListFile([<Path of WDD File> [, <Password of WDD File>, ]] [ <Option>])
<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 File 1> + CR + <Name of File 2> + CR +...
hLstDetail is specified<Name of File 1> + TAB + <Abbreviation> + TAB + <Caption> + TAB + <Physical Name> + CR +...

Where:
  • <Name of 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 WDD>: Optional character string (with quotes)
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 (with quotes)
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.
hLstDetailLists the detailed information (same as WINDEV 5.5).
hLstAllLists all the data files (including the ones described by HDeclare, HDeclareExternal and HDescribeFile).
Hyper File 5.5 This parameter is ignored.
hLstSortedSorts the list of data files in ascending order.
Hyper File 5.5 This parameter is ignored.
WINDEVWEBDEV - Server codeReports and QueriesiPhone/iPadWindows MobileUniversal Windows 10 AppPHPAjaxUser code (UMC)HFSQL Client/ServerOLE DBNative Accesses

Listing the data files of a group Hide the details

<Result> = HListFile(<Group Name> [, <Options>])
<Result>: Character string
List of data files belonging to the group. The descriptions of each data file are separated by a CR character (Carriage Return).
<Group Name>: Character string (with or without quotes)
Name of the group of files. This group of files was defined in the data model editor.
<Options>: Optional Integer constant (or combination of constants)
Configures the type of data files to list:
hLstStoredProcedureList of stored procedures.
Versions 19 and later
hLstQuery
New in version 19
hLstQuery
hLstQuery
Lists the queries that have been run.
hLstTable
(default value)
List of user tables.
HFSQL Client/Server The names of tables correspond to the physical names of data files.
hLstSystemTableList of system tables.
HFSQL Client/Server This option is not available.
hLstViewList of views.
Versions 18 and later
Native Accesses Native Oracle Access: The hLstView constant is used to list the views and the synonyms.
New in version 18
Native Accesses Native Oracle Access: The hLstView constant is used to list the views and the synonyms.
Native Accesses Native Oracle Access: The hLstView constant is used to list the views and the synonyms.

HFSQL Client/Server This option is not available.
Versions 20 and later
HFSQL Client/Server Lists the SQL views.
New in version 20
HFSQL Client/Server Lists the SQL views.
HFSQL Client/Server Lists the SQL views.
Versions 20 and later
hLstMaterializedView
New in version 20
hLstMaterializedView
hLstMaterializedView
HFSQL Client/Server List of materialized views.
WINDEVWEBDEV - Server codeWINDEV MobileReports and QueriesPHPAjaxUser code (UMC)HFSQL Client/ServerOLE DBNative Accesses

Listing the data files of a connection via Native Access, OLE DB or HFSQL Client/Server (1) Hide the details

<Result> = HListFile(<Connection Name> [, <Options>])
<Result>: Character string
List of data files accessible by the connection. The descriptions of each data file are separated by a CR character (Carriage Return).
<Connection Name>: Character string (with or without quotes)
Name of connection to a database. This connection was defined in the data model editor or by HOpenConnection.
<Options>: Optional Integer constant (or combination of constants)
Configures the type of data files to list:
hLstStoredProcedureList of stored procedures.
Versions 19 and later
hLstQuery
New in version 19
hLstQuery
hLstQuery
Lists the queries that have been run.
hLstTable
(default value)
List of user tables.
HFSQL Client/Server The names of tables correspond to the physical names of data files.
hLstSystemTableList of system tables.
HFSQL Client/Server This option is not available.
hLstViewList of views.
Versions 18 and later
Native Accesses Native Oracle Access: The hLstView constant is used to list the views and the synonyms.
New in version 18
Native Accesses Native Oracle Access: The hLstView constant is used to list the views and the synonyms.
Native Accesses Native Oracle Access: The hLstView constant is used to list the views and the synonyms.

HFSQL Client/Server This option is not available.
Versions 20 and later
HFSQL Client/Server Lists the SQL views.
New in version 20
HFSQL Client/Server Lists the SQL views.
HFSQL Client/Server Lists the SQL views.
Versions 20 and later
hLstMaterializedView
New in version 20
hLstMaterializedView
hLstMaterializedView
HFSQL Client/Server List of materialized views.
WINDEVWEBDEV - Server codeReports and QueriesAndroidAndroid Widget JavaPHPAjaxUser code (UMC)HFSQL Client/ServerOLE DBNative Accesses

Listing the data files of a connection via Native Access, OLE DB or HFSQL Client/Server (1) Hide the details

<Result> = HListFile(<Connection Name> [, <Options>])
<Result>: Character string
List of data files accessible by the connection. The descriptions of each data file are separated by a CR character (Carriage Return).
<Connection Name>: Character string (with or without quotes)
Name of connection to a database. This connection was defined in the data model editor or by HOpenConnection.
<Options>: Optional Integer constant (or combination of constants)
Configures the type of data files to list:
hLstStoredProcedureList of stored procedures.
hLstQueryLists the queries that have been run.
hLstTable
(default value)
List of user tables.
HFSQL Client/Server The names of tables correspond to the physical names of data files.
hLstSystemTableList of system tables.
HFSQL Client/Server This option is not available.
hLstViewList of views.
Native Accesses Native Oracle Access: The hLstView constant is used to list the views and the synonyms.

HFSQL Client/Server Lists the SQL views.
hLstMaterializedView
HFSQL Client/Server List of materialized views.
WINDEVWEBDEV - Server codeWINDEV MobileReports and QueriesAjaxUser code (UMC)OLE DBNative Accesses

Listing the data files of a connection via Native Access or OLE DB (2) Hide the details

<Result> = HListFile(<User Name> , <Password> , <Data Source> , <OLE DB Provider or Native Access> [, <Access> [, <Options>]])
<Result>: Character string
List of data files accessible by the connection. The descriptions of each data file are separated by a CR character (Carriage Return).
<User Name>: Character string (with quotes)
Name of user of the data source.
<Password>: Character string (with quotes)
Password defined for the access to the data source (if it exists), empty string ("") if no password is defined.
<Data Source>: Character string (with quotes)
Full path of data source used.
<OLE DB Provider or Native Access>: Character string (with quotes) or constant
Name of OLE DB provider or one of the following constants:
hAccessHF7Pseudo-connection to HFSQL Classic database.
hAccessHFClientServerNative Access to HFSQL Client/Server database.
hNativeAccessAS400Native AS/400 access (optional module of WINDEV/WEBDEV).
hNativeAccessDB2Native DB2 access (optional module of WINDEV/WEBDEV).
hNativeAccessInformixNative Informix access (optional module of WINDEV/WEBDEV).
Versions 20 and later
hNativeAccessMariaDB
New in version 20
hNativeAccessMariaDB
hNativeAccessMariaDB
Native MariaDB access (optional module of WINDEV/WEBDEV).
hNativeAccessMySQLNative MySQL access (optional module of WINDEV/WEBDEV).
hNativeAccessOracleNative Oracle access (optional module of WINDEV/WEBDEV).
hNativeAccessOracleLiteNative Oracle access (optional module of WINDEV Mobile).
hNativeAccessPostgreSQLNative PostgreSQL access (optional module of WINDEV/WEBDEV).
hNativeAccessProgressNative Progress access (optional module of WINDEV/WEBDEV).
Versions 16 and later
hNativeAccessSQLAzure
New in version 16
hNativeAccessSQLAzure
hNativeAccessSQLAzure
Native SQL Azure access (optional module of WINDEV/WEBDEV, supplied with the Native SQL Server access).
Versions 16 and later
hNativeAccessSQLite
New in version 16
hNativeAccessSQLite
hNativeAccessSQLite
Native SQLite access.
hNativeAccessSQLServerNative SQL Server access (optional module of WINDEV/WEBDEV).
hNativeAccessSQLServerMobileNative SQL Server access (optional module of WINDEV Mobile).
hNativeAccessSybaseNative Sybase access (optional module of WINDEV/WEBDEV).
hNativeAccessXBaseNative xBase access (supplied with WINDEV/WEBDEV).
hNativeAccessXMLNative XML access (supplied with WINDEV/WEBDEV).
hODBCOLE DB provider for ODBC (used to access an ODBC data source declared in the ODBC data sources of Windows).
hOledbAccess97OLE DB provider for Access 97.
hOledbAccess2000OLE DB provider for Access 2000.
hOledbAccess2007OLE DB provider for Access 2007.
Versions 19 and later
hOledbAccess2010
New in version 19
hOledbAccess2010
hOledbAccess2010
OLE DB provider for Access 2010.
hOledbDBase5OLE DB provider for dBase 5.
hOledbExcel2000OLE DB provider for Excel 2000.
hOledbExcel2007OLE DB provider for Excel 2007.
hOledbExcel97OLE DB provider for Excel 97.
hOledbLotus4OLE DB provider for Lotus 4.
hOledbOracleOLE DB provider for Oracle.
hOledbSQLServerOLE DB provider for SQL Server.
Caution: To use an OLE DB connection, you must:
  • install MDAC version 2.6 or later (setup performed by WINDEV/WEBDEV and when creating the client version)
  • install the OLE DB provider corresponding to the database used.
Windows Mobile The following native accesses can be used:
hAccessHF7Pseudo-connection to HFSQL Classic database.
hNativeAccessOracleNative Oracle access (optional module).
hNativeAccessSQLServerNative SQL Server access (optional module).
PHP The following native accesses can be used:
hNativeAccessAS400Native AS/400 access (optional module of WEBDEV).
Versions 20 and later
hNativeAccessMariaDB
New in version 20
hNativeAccessMariaDB
hNativeAccessMariaDB
Native MariaDB access (optional module of WINDEV/WEBDEV).
hNativeAccessMySQLNative MySQL access (optional module of WEBDEV).
Versions 15 and later
hNativeAccessOracle
New in version 15
hNativeAccessOracle
hNativeAccessOracle
Native Oracle access (optional module of WEBDEV).
Versions 15 and later
hNativeAccessPostgreSQL
New in version 15
hNativeAccessPostgreSQL
hNativeAccessPostgreSQL
Native PostgreSQL access (optional module of WEBDEV).
<Access>: Integer constant (optional)
Type of access to the database:
hOReadWrite
(default value)
Opening in Read/Write.
hOReadOpening in read-only.
<Options>: Optional Integer constant (or combination of constants)
Configures the type of data files to list:
hLstStoredProcedureList of stored procedures.
HFSQL Client/Server This option is not available.
Versions 19 and later
hLstQuery
New in version 19
hLstQuery
hLstQuery
Lists the queries that have been run.
hLstTable
(default value)
List of user tables.
HFSQL Client/Server The names of tables correspond to the physical names of data files.
hLstSystemTableList of system tables.
HFSQL Client/Server This option is not available.
hLstViewList of views.
Versions 18 and later
Native Accesses Native Oracle Access: The hLstView constant is used to list the views and the synonyms.
New in version 18
Native Accesses Native Oracle Access: The hLstView constant is used to list the views and the synonyms.
Native Accesses Native Oracle Access: The hLstView constant is used to list the views and the synonyms.

HFSQL Client/Server This option is not available.
Versions 20 and later
HFSQL Client/Server Lists the SQL views.
New in version 20
HFSQL Client/Server Lists the SQL views.
HFSQL Client/Server Lists the SQL views.
Versions 20 and later
hLstMaterializedView
New in version 20
hLstMaterializedView
hLstMaterializedView
HFSQL Client/Server List of materialized views.
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.
WINDEVWEBDEV - Server codeNative Accesses

HListFile function and the native MySQL or MariaDB access

  • For the Native MySQL access, HListFile has evolved according to the versions:
    • In version 15, HListFile returns the list of files found in the current database.
    • In version 16, to be able to use the new features of MySQL 5, if the Native Access is connected to a MySQL 5 server (or later), HListFile returns the list of files found in all the accessible databases. In this case, the name of the file has the following format: "<Database name>.<File name>.
    • From version 170069, HListFile returns the list of files found in the current database. HListDatabase is used to list the accessible databases and their files.
  • Versions 20 and later
    For the Native MariaDB access, HListFile returns the list of files for the current database. HListDatabase is used to list the accessible databases and their files.
    New in version 20
    For the Native MariaDB access, HListFile returns the list of files for the current database. HListDatabase is used to list the accessible databases and their files.
    For the Native MariaDB access, HListFile returns the list of files for the current database. HListDatabase is used to list the accessible databases and their files.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment