PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
  • 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 using different WLanguage properties.
This type of variable is used by the hScheduledOptimization type.
Remark: See Declaring a variable for more details on the declaration of this type of variable and the use of WLanguage properties.
Versions 17 and later
iPhone/iPad This type of variable is now available for iPhone and iPad applications.
New in version 17
iPhone/iPad This type of variable is now available for iPhone and iPad applications.
iPhone/iPad This type of variable is now available for iPhone and iPad applications.
Example
// Recalculer les statistiques des fichier de la base "MaBase",
// tous les samedis à 23H00
Optim is hScheduledOptimization
Optim.Description = "Recalcul des statistiques des fichiers de la base de données MaBase"
 
Optim.Scheduling.Month = "*"
Optim.Scheduling.DayOfWeek = "samedi"
Optim.Scheduling.Hour = "23"
Optim.Scheduling.Minute = "0"
 
Optim.File[1].Nom = "MaBase"
Optim.File[1].Option = hOptStat
 
HAddScheduledOptimization(MaConnexion, 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 write mode.
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 re-indexing operation on the data files. A hot re-indexing 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.
Minimum version required
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment