HListREP (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

Compatibility with the earlier versions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HListREP (Function)

In french: HListeREP

Available only with these kinds of connection

Returns the list of assignments for the data files handled by the current application, which means the list of physical files corresponding to the data files described in the analysis.

For more details on this list, see List of data files handled by an application.

Example

sAssignments is string
// Retrieve all the assignments of the logical file
// CUSTOMER whose physical name is CUSTOMER2000 and that
// exist on disk
sAssignments = HListREP(".", "CUSTOMER", "CUSTOMER2000", hExisting)

// List all the entries in the .REP file of the project
// Equivalent syntax: HListREP()
sList is string
sList = HListREP(".","*")

Syntax

Listing the assignments from the .REP file Hide the details

<Result> = HListREP([<Name of REP file> [, <Logical file name> [, <Physical file name>]]] [, <Options>])

<Result>: Character string

List of assignments,
Empty string ("") if an error occurred.
The list of assignments has the following format:
<Logical name> + <TAB> + <Physical name> + TAB + <Directory> + CR +...

Where:
<Nom logique> Name of the data file in the analysis.
<Nom physique> Physical file name, without path or extension.
<Répertoire> Physical file directory.
<Result> is filled with 2 new details:
<Nom du serveur> HFSQL Client/Server server name.
<Nom de la base de données> HFSQL Client/Server database name.

<Name of REP file>: Optional character string

Full name of the analyzed .REP file.
If this parameter corresponds to an empty string or to ".", the current ".REP" file is examined.
The current ".REP" file is also examined if the first three optional parameters are not specified.
This parameter cannot be specified on its own. The following syntax is not available: HListREP(<Name of .REP file>).

<Logical file name>: Optional character string

Logical name of the data file whose assignments must be listed. If this parameter is not specified or if it is equal to "*", all the assignments of all the data files will be sought.

<Physical file name>: Optional character string

Physical name of the data file whose assignments must be listed. If this parameter is not specified, all the assignments of <Logical File Name> will be sought.

<Options>: Optional integer constant

All the assignments are sought by default. The hExisting constant is used to find the assignments for which a data file actually exists.

Assignment list from .WDD file Hide the details

<Result> = HListREP([<Name of WDD file> [, <Logical file name> [, <Physical file name>]]] [, <Options>])

<Result>: Character string

List of assignments,
Empty string ("") if an error occurred.
The list of assignments has the following format:
<Logical name> + <TAB> + <Physical name> + TAB + <Directory> + CR +...

where:
<Nom logique> Name of the data file in the analysis.
<Nom physique> Physical file name, without path or extension.
<Répertoire> Physical file directory.

<Name of WDD file>: Optional character string

Full name of the examined .WDD file.
The current "WDD" file is examined if this parameter is not specified or if it corresponds to ".".
Multi-analysis projects: If this parameter is not specified or is set to ".", the ".WDD" file for the main analysis is examined.

<Logical file name>: Optional character string

Logical name of the data file whose assignments must be listed. If this parameter is not specified or if it is equal to "*", all the assignments of all the data files will be sought.

<Physical file name>: Optional character string

Physical name of the data file whose assignments must be listed. If this parameter is not specified, all the assignments of <Logical File Name> will be sought.

<Options>: Optional integer constant

All the assignments are sought by default. The hExisting constant is used to find the assignments for which a data file actually exists.

Remarks

Compatibility with the earlier versions

The following syntax is not available anymore: HListREP(<WDD name>, "?").

Business / UI classification: Business Logic

Component: wd300hf.dll