PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • 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 scheduled optimization task can be defined and modified by several WLanguage properties.
Note: See "Declaring a variable" for more details.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 17 and later
iPhone/iPad This feature is now available for the iPhone and iPad applications.
New in version 17
iPhone/iPad This feature is now available for the iPhone and iPad applications.
iPhone/iPad This feature 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 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.
Note: These properties can be used with one of the following syntaxes:
  • <Variable Name>..<Property Name>
  • <Variable Name>.<Property Name>

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 required version
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment