ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
  • Necessary rights
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Adds an optimization task of HFSQL Client/Server data files.
Example
// Description de la connexion
MaConnexion is Connection
...
// 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].Name = "MaBase"
Optim.File[1].Option = hOptStat
MaConnexion.AddScheduledOptimization(Optim)
Syntax
<Result> = <Connection>.AddScheduledOptimization(<Scheduled optimization task>)
<Result>: Boolean
  • True if the scheduled optimization task was added
  • False if an error occurs. HErrorInfo is used to identify the error.
<Connection>: Connection variable
Name of the Connection variable that describes the connection for which a scheduled optimization task must be added.
<Scheduled optimization task>: hScheduledOptimization variable
Name of the hScheduledOptimization variable used.
Remarks

Necessary rights

To add a scheduled optimization task, you must have:
  • the corresponding rights (hRightsManageTask constant) on the server,
  • the rights to connect (hRightsConnection or hRightsEncryptedConnection) to each relevant database,
  • the rights to run the command linked to the scheduled optimization task.
The task will be run with the account of user who created the task.
For full server optimization, the user must be a superuser.
Note: If the server is off, the scheduled optimization task will not be performed. The scheduled optimization task will be performed at the next available date when the server is switched on.
To find out whether these rights are granted to a user or to a group, use <Connection variable>.InfoServerRights or <Connection variable>.InfoDatabaseRights.
To modify the rights granted to a user or group of users, use <Connection variable>.ModifyServerRights or <Connection variable>.ModifyDatabaseRights.
Component: wd300hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/12/2025

Send a report | Local help