PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

New WINDEV, WEBDEV, WINDEV Mobile 25 feature!
  • Necessary rights
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
<Connection variable>.ListScheduledOptimization (Function)
In french: <Variable Connexion>.ListeOptimisationPlanifiée
HFSQL Client/ServerAvailable only with this kind of connection
Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
MyConnection is Connection
...
arrOptim is array of hScheduledOptimization
arrOptim = MyConnection.ListScheduledOptimization()
FOR EACH Optim OF arrOptim
DisplayInfo(Optim)
END
Syntax
<Result> = <Connection>.ListScheduledOptimization()
<Result>: Array of hScheduledOptimization variables
Array of hScheduledOptimization variable. Each element found in this array contains the characteristics of a scheduled optimization task. The number of elements in this array corresponds to the number of available scheduled optimization tasks.
<Connection>: Connection variable
Name of the Connection variable that describes the connection for which the scheduled optimization tasks must be listed.
Remarks
Versions 23 and later

Necessary rights

To list the scheduled optimization tasks, you must have the rights to connect (hRightsConnection or hRightsEncryptedConnection constant) to each relevant database,
For a full server optimization, the user must be a super-user.
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 to a group of users, use <Variable Connexion>.ModifieDroitServeur or <Variable Connexion>.ModifieDroitBaseDeDonnées.
New in version 23

Necessary rights

To list the scheduled optimization tasks, you must have the rights to connect (hRightsConnection or hRightsEncryptedConnection constant) to each relevant database,
For a full server optimization, the user must be a super-user.
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 to a group of users, use <Variable Connexion>.ModifieDroitServeur or <Variable Connexion>.ModifieDroitBaseDeDonnées.

Necessary rights

To list the scheduled optimization tasks, you must have the rights to connect (hRightsConnection or hRightsEncryptedConnection constant) to each relevant database,
For a full server optimization, the user must be a super-user.
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 to a group of users, use <Variable Connexion>.ModifieDroitServeur or <Variable Connexion>.ModifieDroitBaseDeDonnées.
Component : wd250hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment