ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

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
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
HListREP (Function)
In french: HListeREP
HFSQL ClassicHFSQL Client/ServerAvailable 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
sAffectations is string
// Récupérer toutes les affectations du fichier logique
// CLIENT dont le nom physique est CLIENT2000 et qui
// existent bien sur disque
sAffectations = HListREP(".", "CLIENT", "CLIENT2000", hExisting)
WINDEVWEBDEV - Server codeReports and QueriesUser code (UMC)External languageAjaxHFSQL ClassicHFSQL Client/ServerHyper File 5.5
// Lister toutes les entrées du .REP du projet
// Syntaxe équivalente: HListeREP()
sListe is string
sListe = 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:
<Nom logique> + TAB + <Nom physique> + TAB + <Répertoire> + RC + ...

Where:
  • <Logical name>: Name of the data file in the analysis.
  • <Physical name>: Physical file name, without path and without extension.
  • <Directory>: Directory of physical file.
HFSQL Client/Server <Result> is filled with 2 new details:
  • <Server name>: Name of the HFSQL Client/Server server.
  • <Database name>: Name of the HFSQL Client/Server database.
<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.
Hyper File 5.5 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> are searched.
<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.

Listing the assignments from the .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:
<Nom logique> + TAB + <Nom physique> + TAB + <Répertoire> + RC + ...

where:
  • <Logical name>: Name of the data file in the analysis.
  • <Physical name>: Physical file name, without path and without extension.
  • <Directory>: Directory of physical file.
<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 ".".
<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> are searched.
<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
WINDEVWEBDEV - Server codeReports and QueriesUser code (UMC)External languageAjaxHFSQL ClassicHFSQL Client/ServerHyper File 5.5

Compatibility with the earlier versions

The following syntax is not available anymore: HListREP(<WDD name>, "?").
Business / UI classification: Business Logic
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help