ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Why include the data files in a library?
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
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: The physical data files can be found:
  • on disk (most common case).
  • in the WINDEV libraries (WDL files).
  • in the executable.
  • in a component.
Example
// Find data files in libraries 4, 6 and 9
HChangeLocation(CustomerFile, 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 HChangeLocation is used, <Result> = True, but the function has no effect: the data files used are always found 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).
Caution: the affected data files 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 <Parameter> is not specified: Searches for the data files in the WDLs according to the load order, then on disk.
    If <Parameter> is specified: Searches for the data files in the specified WDLs, 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:
  • protecting data: the data files are accessible in read-only.
  • grouping data: all the files required by the execution are grouped in a single file.
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/26/2022

Send a report | Local help