HListFile (Function)

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.

To optimize the size of the applications, the OLE DB drivers are not available in this version.

Versiones 17 y posteriores

This function is now available for iPhone/iPad applications.

Nueva funcionalidad versión 17

This function is now available for iPhone/iPad applications.

Versiones 18 y posteriores

This function is now available in Windows Store apps mode.

Nueva funcionalidad versión 18

This function is now available in Windows Store apps mode.

Versiones 19 y posteriores

This function is now available for the WEBDEV sites in PHP.

Nueva funcionalidad versión 19

This function is now available for the WEBDEV sites in PHP.

This function is now available for the WEBDEV sites in PHP.

Versiones 21 y posteriores

This function is now available in Universal Windows 10 App mode.

Nueva funcionalidad versión 21

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.

Versiones 22 y posteriores

This function is now available in Android Widget mode.

This function is now available for Java applications.

This function is now available for Android applications.

Nueva funcionalidad versión 22

This function is now available in Android Widget mode.

This function is now available for Java applications.

This function is now available for Android applications.

This function is now available in Android Widget mode.

This function is now available for Java applications.

This function is now available for Android applications.

Ejemplo

// Retrieve the files described in the analysis and by programming
FileList is string
FileList = HListFile(hLstDétail + hLstAll)

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

// Display in a trace
Trace(FileList)

Sintaxis

Listing the files of an analysis Ocultar los detalles

<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.
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).
This parameter is ignored.
hLstSorted Sorts the list of data files in ascending order.
This parameter is ignored.

Listing the data files of a group Ocultar los detalles

<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:
hLstStoredProcedure List of stored procedures.
Versiones 19 y posteriores
hLstQuery
Nueva funcionalidad versión 19
hLstQuery
hLstQuery Lists the queries that have been run.
hLstTable
(default value) List of user tables.
The names of tables correspond to the physical names of data files.
hLstSystemTable List of system tables.
This option is not available.
hLstView List of views.
Versiones 18 y posteriores
Native Oracle Access: The hLstView constant is used to list the views and the synonyms.
Nueva funcionalidad versión 18
Native Oracle Access: The hLstView constant is used to list the views and the synonyms.
Native Oracle Access: The hLstView constant is used to list the views and the synonyms.

This option is not available.
Versiones 20 y posteriores
Lists the SQL views.
Nueva funcionalidad versión 20
Lists the SQL views.
Lists the SQL views.
Versiones 20 y posteriores
hLstMaterializedView
Nueva funcionalidad versión 20
hLstMaterializedView
hLstMaterializedView
List of materialized views.

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

<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:
hLstStoredProcedure List of stored procedures.
Versiones 19 y posteriores
hLstQuery
Nueva funcionalidad versión 19
hLstQuery
hLstQuery Lists the queries that have been run.
hLstTable
(default value) List of user tables.
The names of tables correspond to the physical names of data files.
hLstSystemTable List of system tables.
This option is not available.
hLstView List of views.
Versiones 18 y posteriores
Native Oracle Connector: The hLstView constant is used to list the views and the synonyms.
Nueva funcionalidad versión 18
Native Oracle Connector: The hLstView constant is used to list the views and the synonyms.
Native Oracle Connector: The hLstView constant is used to list the views and the synonyms.

This option is not available.
Versiones 20 y posteriores
Lists the SQL views.
Nueva funcionalidad versión 20
Lists the SQL views.
Lists the SQL views.
Versiones 20 y posteriores
hLstMaterializedView
Nueva funcionalidad versión 20
hLstMaterializedView
hLstMaterializedView
List of materialized views.

Listing the data files of a connection via Native Connectors, OLE DB or HFSQL Client/Server (1) Ocultar los detalles

<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:
hLstStoredProcedure List of stored procedures.
hLstQuery Lists the queries that have been run.
hLstTable
(default value) List of user tables.
The names of tables correspond to the physical names of data files.
hLstSystemTable List of system tables.
This option is not available.
hLstView List of views.
Native Oracle Connector: The hLstView constant is used to list the views and the synonyms.

Lists the SQL views.
hLstMaterializedView
List of materialized views.

Listing the data files of a connection via Native Connectors or OLE DB (2) Ocultar los detalles

<Result> = HListFile(<User name> , <Password> , <Data source> , <OLE DB provider or Native Connector> [, <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 Connector>: Character string (with quotes) or constant

Name of OLE DB provider or one of the following constants:
hAccessHF7 Pseudo-connection to HFSQL Classic database.
hAccessHFClientServer Native Connector to an HFSQL Client/Server database.
hNativeAccessAS400 Native AS/400 Connector (optional module of WINDEV/WEBDEV).
hNativeAccessDB2 Native DB2 Connector (optional module of WINDEV/WEBDEV).
hNativeAccessInformix Native Informix Connector (optional module of WINDEV/WEBDEV).
Versiones 20 y posteriores
hNativeAccessMariaDB
Nueva funcionalidad versión 20
hNativeAccessMariaDB
hNativeAccessMariaDB Native MariaDB Connector (optional module of WINDEV/WEBDEV).
hNativeAccessMySQL Native MySQL Connector (optional module of WINDEV/WEBDEV).
hNativeAccessOracle Native Oracle Connector (optional module of WINDEV/WEBDEV).
hNativeAccessOracleLite Native Oracle Connector (optional module of WINDEV Mobile).
hNativeAccessPostgreSQL Native PostgreSQL Connector (optional module of WINDEV/WEBDEV).
hNativeAccessProgress Native Progress Connector (optional module of WINDEV/WEBDEV).
Versiones 16 y posteriores
hNativeAccessSQLAzure
Nueva funcionalidad versión 16
hNativeAccessSQLAzure
hNativeAccessSQLAzure Native SQL Azure Connector (optional module of WINDEV/WEBDEV, supplied with Native SQL Server Connector).
Versiones 16 y posteriores
hNativeAccessSQLite
Nueva funcionalidad versión 16
hNativeAccessSQLite
hNativeAccessSQLite Native SQLite Connector.
hNativeAccessSQLServer Native SQL Server Connector (optional module of WINDEV/WEBDEV).
hNativeAccessSQLServerMobile Native SQL Server Connector (optional module of WINDEV Mobile).
hNativeAccessSybase Native Sybase Connector (optional module of WINDEV/WEBDEV).
hNativeAccessXBase Native xBase Connector (supplied with WINDEV/WEBDEV).
hNativeAccessXML Native XML Connector (supplied with WINDEV/WEBDEV).
hODBC OLE DB provider for ODBC (used to access an ODBC data source declared in the ODBC data sources of Windows).
hOledbAccess97 OLE DB provider for Access 97.
hOledbAccess2000 OLE DB provider for Access 2000.
hOledbAccess2007 OLE DB provider for Access 2007.
Versiones 19 y posteriores
hOledbAccess2010
Nueva funcionalidad versión 19
hOledbAccess2010
hOledbAccess2010 OLE DB provider for Access 2010.
hOledbDBase5 OLE DB provider for dBase 5.
hOledbExcel2000 OLE DB provider for Excel 2000.
hOledbExcel2007 OLE DB provider for Excel 2007.
hOledbExcel97 OLE DB provider for Excel 97.
hOledbLotus4 OLE DB provider for Lotus 4.
hOledbOracle OLE DB provider for Oracle.
hOledbSQLServer OLE 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.
Only the following Native Connectors can be used:
hAccessHF7 Pseudo-connection to HFSQL Classic database.
hNativeAccessOracle Native Oracle Connector (optional module).
hNativeAccessSQLServer Native SQL Server Connector (optional module).
Only the following Native Connectors can be used:
hNativeAccessAS400 Native AS/400 Connector (optional module of WEBDEV).
Versiones 20 y posteriores
hNativeAccessMariaDB
Nueva funcionalidad versión 20
hNativeAccessMariaDB
hNativeAccessMariaDB Native MariaDB Connector (optional module of WINDEV/WEBDEV).
hNativeAccessMySQL Native MySQL Connector (optional module of WEBDEV).
Versiones 15 y posteriores
hNativeAccessOracle
Nueva funcionalidad versión 15
hNativeAccessOracle
hNativeAccessOracle Native Oracle Connector (optional module of WEBDEV).
Versiones 15 y posteriores
hNativeAccessPostgreSQL
Nueva funcionalidad versión 15
hNativeAccessPostgreSQL
hNativeAccessPostgreSQL Native PostgreSQL Connector (optional module of WEBDEV).

<Access>: Integer constant (optional)

Type of access to the database:
hOReadWrite
(default value) Opening in Read/Write.
hORead Opening in read-only.

<Options>: Optional Integer constant (or combination of constants)

Configures the type of data files to list:
hLstStoredProcedure List of stored procedures.
This option is not available.
Versiones 19 y posteriores
hLstQuery
Nueva funcionalidad versión 19
hLstQuery
hLstQuery Lists the queries that have been run.
hLstTable
(default value) List of user tables.
The names of tables correspond to the physical names of data files.
hLstSystemTable List of system tables.
This option is not available.
hLstView List of views.
Versiones 18 y posteriores
Native Oracle Connector: The hLstView constant is used to list the views and the synonyms.
Nueva funcionalidad versión 18
Native Oracle Connector: The hLstView constant is used to list the views and the synonyms.
Native Oracle Connector: The hLstView constant is used to list the views and the synonyms.

This option is not available.
Versiones 20 y posteriores
Lists the SQL views.
Nueva funcionalidad versión 20
Lists the SQL views.
Lists the SQL views.
Versiones 20 y posteriores
hLstMaterializedView
Nueva funcionalidad versión 20
hLstMaterializedView
hLstMaterializedView
List of materialized views.

Observaciones

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.

HListFile function and the Native MySQL or MariaDB Connector

For the Native MySQL Connector, HListFile has evolved along with 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 Connector is connected to a MySQL 5 server (or later), HListFile returns the list of files from all 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.
Versiones 20 y posteriores
For the Native MariaDB Connector, HListFile returns the list of files from the current database. HListDatabase is used to list the accessible databases and their files.
Nueva funcionalidad versión 20
For the Native MariaDB Connector, HListFile returns the list of files from the current database. HListDatabase is used to list the accessible databases and their files.
For the Native MariaDB Connector, HListFile returns the list of files from the current database. HListDatabase is used to list the accessible databases and their files.

Componente : wd240hf.dll

Versión mínima requerida

Versión 9

Esta página también está disponible para…

Comentarios

Haga clic en [Agregar] para publicar un comentario

Última modificación: 27/06/2019

Señalar un error o enviar una sugerencia | Ayuda local