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.
Versions 17 and later
New in version 17Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later New in version 22
// Find files in libraries 4, 6 and 9
HChangeLocation(CustomerFile, hWDL, 4, 6, 9)
Syntax
<Result> = HChangeLocation(<File name> , <Search mode> [, <Parameters>])
<Result>: Boolean
- True if the operation was performed,
- False if a problem occurred. HError is used to identify the error.
<File name>: Character string (with or without quotes)
Logical name of the data file (defined in the analysis).
If this parameter is equal to "*", the change of search mode will be applied to 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: | |
| hDisk | The data files are sought on disk only. This is the most common case. |
hWDL
(Default value) | The data files are sought:- In the main WDL;
- 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. - In the main WDL of the component.
- In the secondary WDLs of the component according to the load order.
|
<Parameters>: Optional character string (with quotes)
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.