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
  • Why include the data files in a library?
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
HChangeLocation (Function)
In french: HChangeLocalisation
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
Modifies the search mode of physical data files (.FIC, .NDX, ...). By default, the physical data files are sought in the application library then on disk.
Reminder: Physical data files can be found:
  • on disk (most common case).
  • in the WINDEV libraries (WDL files).
  • in the executable.
  • in a component.
Example
// Recherche des fichiers de données dans les bibliothèques 4, 6 et 9
HChangeLocation(FichierClient, hWDL, 4, 6, 9)
Syntax
<Result> = HChangeLocation(<Data file> , <Search mode> [, <Parameters>])
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurs. HError is used to identify the error.
HFSQL Client/Server If the function HChangeLocation is used, <Result> = True, but the function has no effect: the data files being manipulated are still on the server.
<Data file>: Character string
Name of the data file (defined in the analysis).
If this parameter is equal to "*", the search mode will change for all the known data files (described in the analysis).
Attention: the data files concerned are automatically closed..
This parameter can also correspond to the name of a group of files (or custom-folder) defined in the analysis.
<Search mode>: Constant
Configures the search mode of data files:
hDiskThe data files are sought on disk only. This is the most common case.
hWDL
(Default value)
The data files are sought:
  1. In the main WDL;
  2. If <Paramètres> is not specified: searches for data files in WDLs in order of loading, then on disk.
    If <Paramètres> is specified: Searches for data files in the specified WDL(s), then on disk.
  3. In the main WDL of the component.
  4. In the secondary WDLs of the component according to the load order.
<Parameters>: Optional character string
Identifier of the WDLs where the search must be performed. These WDLs must be loaded by LoadWDL that returns the identifier of the WDL.
Remarks

Why include the data files in a library?

Including the data files in a library presents the following benefits:
  • data protection: data files are read-only.
  • data grouping: all files required for execution are grouped together in a single file.
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help