ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
  • Necessary rights
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection.
Example
MyConnection is Connection
...
arrOptim is array of hScheduledOptimization
arrOptim = HListScheduledOptimization(MyConnection)
FOR EACH Optim OF arrOptim
DisplayInfo(Optim)
END
Syntax
<Result> = HListScheduledOptimization(<Connection>)
<Result>: Array of hScheduledOptimization variables
Array of a variable of type hScheduledOptimization. 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>: Character string or Connection variable
Connection for which the scheduled optimization tasks must be listed. This connection corresponds to:
Remarks

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 HInfoServerRights or HInfoDatabaseRights.
To modify the rights granted to a user or to a group of users, use HModifyServerRights or HModifyDatabaseRights.
Component: wd290hf.dll
Minimum version required
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help