ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / Types of HFSQL variables
  • Properties specific to hFileParameter variables
  • Functions that use hFileParameter variables
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
hFileParameter (Variable type)
In french: hParamètreFichier
HFSQL Client/ServerAvailable only with this kind of connection
The hFileParameter type is used to define the data files taken into account by a scheduled optimization task. You can define and change the characteristics of these data files using different WLanguage properties.
This type of variable is used by the hScheduledOptimization type and by various WLanguage functions.
Note: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.
Example
// Recalculate the statistics for the files found in "MyDatabase", 
// every Saturday at 23:00
Optim is hScheduledOptimization
Optim.Description = "Recalculating the statistics for the files found in the MyDatabase database"

Optim.Scheduling.Month = "*"
Optim.Scheduling.DayOfWeek = "Saturday"
Optim.Scheduling.Hour = "23"
Optim.Scheduling.Minute = "0"

Optim.File[0].Name = "MyDatabase"
Optim.File[0].Option = hOptStat

HAddScheduledOptimization(MyConnection, Optim)
Properties

Properties specific to hFileParameter variables

The following properties can be used to define the characteristics of hFileParameter variables:
Property nameType usedEffect
NameCharacter stringName of the data file to be processed. This name can correspond to a string of the following type:
  • <Database name>/<Data file name>: Optimization of "Data file name" in "Database name".
  • <Database name>: Optimization of all the data files contained in "Database name".
  • "*": Optimization of all data files in all server databases.
OptionInteger constantOptimization options:
  • hOptIndex: Reindexes all data files. A hot re-indexing operation is performed on the indexes and on the full-text indexes.
  • hOptStat: Recalculates data file statistics. The result is similar to the use of HStatCalculate. This process is a hot process.
Note: This property is only taken into account when using a variable of type hScheduledOptimization.
PasswordCharacter string or Secret stringPassword of the encrypted data files.
New in version 2025
Secret strings: If you use the secret string vault, the type of secret string used for this parameter must be "ANSI or Unicode string".
To learn more about secret strings and how to use the vault, see Secret string vault.
This property is available in write mode.
Remarks

Functions that use hFileParameter variables

Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server data file (.FIC file).
This new function is available from WINDEV Suite SaaS 2025 - Update 2.
Checks the structural integrity of memos in an HFSQL Client/Server data file.
This new function is available from WINDEV Suite SaaS 2025 - Update 2.
Rebuilds the index of an HFSQL Client/Server data file (".NDX" file). This operation is asynchronous, i.e., it is performed on the server and does not block the client side.
This new function is available from WINDEV Suite SaaS 2025 - Update 2.
Gets various statistics on the keys of an HFSQL Client/Server data file.
This new function is available from WINDEV Suite SaaS 2025 - Update 2.
Minimum version required
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/10/2025

Send a report | Local help