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 hScheduledOptimization variables
  • Functions that handle the hScheduledOptimization type
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
hScheduledOptimization (Type of variable)
In french: hOptimisationPlanifiée
HFSQL Client/ServerAvailable only with this kind of connection
The hScheduledOptimization type is used to manage a scheduled optimization task on a HFSQL server by programming. A scheduled optimization task is used to periodically perform statistical calculations or to reindex the data files found on the HFSQL server.
The characteristics of this planned optimization task can be defined and modified using different WLanguage properties.
Remark: See "Declaring a variable" for more details on the declaration of this type of variable and the use of WLanguage properties.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Recalculer les statistiques des fichiers 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 hScheduledOptimization variables

The following properties can be used to handle a hScheduledOptimization variable:
Property nameType usedEffect
EnabledBoolean
  • True if the scheduling of the optimization is enabled,
  • False otherwise.
DescriptionCharacter stringText describing the scheduling of the optimization.
The description of the optimization scheduling corresponds to an empty string ("") by default.
FileArray of hFileParameter variablesDescription of the files that must be taken into account during the optimization.
IdentifierIntegerIdentifier of the optimization task.
This property is available in read-only.
NumberExecutionIntegerNumber of times the task for optimization scheduling must be run. This property can also correspond to the Infinite constant.
SchedulinghScheduling variableCharacteristics of the scheduling.
UserCharacter stringUser who created the task for optimization scheduling.
This property is read-only.

Functions that handle the hScheduledOptimization type

The following functions can be used to handle a hScheduledOptimization variable:
Versions 15 and later
HAddScheduledOptimization
New in version 15
HAddScheduledOptimization
HAddScheduledOptimization
Adds an optimization task of HFSQL Client/Server data files.
Versions 15 and later
HListScheduledOptimization
HListScheduledOptimization
Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection.
Versions 15 and later
HModifyScheduledOptimization
HModifyScheduledOptimization
Modifies a scheduled optimization task on the HFSQL server defined by the connection.
Minimum version required
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment