HListFile (Function)

AYUDA EN LÍNEA
WINDEV, WEBDEV Y WINDEV MOBILE

Versión:

Inicio | Iniciar sesión | Español

Este contenido se ha traducido automáticamente. Haga clic aquí para ver la versión en inglés.

Ayuda / WLanguage / Administrar bases de datos / HFSQL / Funciones HFSQL

HListFile function and the Native MySQL or MariaDB Connector

WINDEV

WEBDEV

WINDEV Mobile

Otros

Ver también

HListFile (Function)

No disponible con este tipo de conexión

Returns the list of data files:

current analysis.
analyses in progress (projects with multiple analyses).
a specific analysis recognized by the HFSQL engine.
available on a connection via a Native Connector or an OLE DB driver.
for a group defined in the data model editor.
The groups defined in the data model editor are not supported.

Ejemplo

Ver ejemplos adicionales

// Recovers data files described in the current analysis and by programming
FileList is string
FileList = HListFile(hLstDetail + hLstAll)
// Add the list of data files in COMBO_COMBO1
ListAdd(COMBO_COMBO1, FileList)
// Display in a trace
Trace(FileList)

Sintaxis

Listing the data files of an analysis Ocultar los detalles

<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.
Case of projects with multiple analyses: If several analyses are in progress, all the files from all the analyses in progress are listed (without duplicates).
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:
<Nom du fichier de données X> Logical name of data file (used in programming).
<Abréviation>: Abbreviation for data file.
<Libellé>: Data file name.
<Nom physique> Physical name of data file (on disk). This name corresponds to the short file name, without extension or path.

<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 is equal to an empty string (""), the data files to be listed are searched:
in the current analysis.
in all current analyses (case of projects with multiple analyses).

<Password of the WDD file>: Optional string or Secret string

Password defined for the analysis.
If no password is defined, this parameter must be an empty string ("").
Novedad versión 2025
Cadenas secretas: Si utiliza el almacén de cadenas secretas, el tipo de cadena secreta utilizado para este parámetro debe ser "ANSI o Unicode string".
Para obtener más información sobre las cadenas secretas y el almacén, consulte Almacén de cadenas secretas.

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

Configures the type of list to perform:
hLstAll Lists all the data files (including the ones described by HDeclare, HDeclareExternal and HDescribeFile).
This parameter is ignored.
hLstDetail Lists the detailed information (same as WINDEV 5.5).
hLstNormal
(default value) List not sorted, not detailed, without the data files described programmatically.
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

Name of the data file group. This group of data files was defined in the data model editor.

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

Configures the type of data files to list:
hLstMaterializedView
List of materialized views.
hLstQuery Lists the queries that have been run.
hLstStoredProcedure List of stored procedures.
hLstSystemTable List of system tables.
This option is not available.
hLstTable
(default value) List of user tables.
The names of tables correspond to the physical names of data files.
hLstView List of views.
Oracle Native Access Access: The constant hLstVue constant is used to list views and synonyms.

Lists the SQL views.

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

<Result> = HListFile(<Connection> [, <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>: Character string

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

Lists the SQL views.

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

<Result> = HListFile(<Username> , <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).

<Username>: Character string

Name of the user of the data source.

<Password>: Character string or Secret string

Password defined for the access to the data source (if it exists), empty string ("") if no password is defined.
Novedad versión 2025
Cadenas secretas: Si utiliza el almacén de cadenas secretas, el tipo de cadena secreta utilizado para este parámetro debe ser "ANSI o Unicode string".
Para obtener más información sobre las cadenas secretas y el almacén, consulte Almacén de cadenas secretas.

<Data source>: Character string

Full path of data source used.

<OLE DB provider or Native Connector>: Character string or constant

Name of the 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).
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).
hNativeAccessSQLAzure Native SQL Azure Connector (optional module of WINDEV/WEBDEV, provided with the Native SQL Server Connector).
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 (provided with WINDEV/WEBDEV).
hNativeAccessXML Native XML Connector (provided 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.
hOledbAccess2010 OLE DB provider for Access 2010.
hOledbDBase5 OLE DB provider for dBase 5.
hOledbExcel97 OLE DB provider for Excel 97.
hOledbExcel2000 OLE DB provider for Excel 2000.
hOledbExcel2007 OLE DB provider for Excel 2007.
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:
hNativeAccessAS400 Native AS/400 Connector (optional module of WEBDEV).
hNativeAccessMariaDB Native MariaDB Connector (optional module of WINDEV/WEBDEV).
hNativeAccessMySQL Native MySQL Connector (optional module of WEBDEV).
hNativeAccessOracle Native Oracle Connector (optional module of WEBDEV).
hNativeAccessPostgreSQL Native PostgreSQL Connector (optional module of WEBDEV).

<Access>: Integer constant (optional)

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

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

Configures the type of data files to list:
hLstMaterializedView
List of materialized views.
hLstQuery Lists the queries that have been run.
hLstStoredProcedure List of stored procedures.
This option is not available.
hLstSystemTable List of system tables.
This option is not available.
hLstTable
(default value) List of user tables.
The names of tables correspond to the physical names of data files.
hLstView List of views.
Oracle Native Connector The constant hLstVue constant is used to list views and synonyms.

Lists the SQL views.

Observaciones

HListFile function and the Native MySQL or MariaDB Connector

For the MySQL Native Connector, the function HListFile function has evolved with each version:
- In version 15, HListFile returns the list of files 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>.
- Starting with version 170069, HListFile returns the list of files in the current database. HListDatabase lists the accessible databases and their files.
For the Native MariaDB Connector, HListFile returns the list of files from the current database. HListDatabase lists the accessible databases and their files.

Componente: wd300hf.dll

Ver también

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: 16/05/2025

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