PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Properties specific to the description of hFileParameter variables
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
hFileParameter (Type of variable)
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. The characteristics of these data files can be defined and modified by several WLanguage properties.
This type of variable is used by the hScheduledOptimization type.
Note: See Declaring a variable for more details.
Versions 17 and later
iPhone/iPad This type of variable is now available for the iPhone and iPad applications.
New in version 17
iPhone/iPad This type of variable is now available for the iPhone and iPad applications.
iPhone/iPad This type of variable is now available for the iPhone and iPad applications.
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[1]..Name = "MyDatabase"
Optim..File[1]..Option = hOptStat

HAddScheduledOptimization(MyConnection, Optim)
Remarks

Properties specific to the description of hFileParameter variables

The following properties can be used to handle a hFileParameter variable:
Property nameType usedEffect
PasswordCharacter stringPassword of the encrypted data files.
This property is available in read-only.
NameCharacter stringName of the file to process. This name can correspond to a string of the following type:
  • <Database Name>/<File Name>: Optimizing the "File Name" file in the "Database Name" database.
  • <Database Name>: Optimizing all the data files found in the "Database Name" database.
  • "*": Optimizing all the data files found in all the databases of the server.
OptionInteger constantOptimization options:
  • hOptIndex: Provokes the reindexing operation on the data files. A hot reindexing operation is performed on the indexes and on the full-text indexes.
  • hOptStat: Provokes the recalculation of statistics on the data files. The result is similar to the use of HStatCalculate. This process is a hot process.
Note: These properties can be used with one of the following syntaxes:
  • <Variable Name>..<Property Name>
  • <Variable Name>.<Property Name>
Minimum required version
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment