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
Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection.
Example
MaConnexion is Connection
...
tabOptim is array of hScheduledOptimization
tabOptim = HListScheduledOptimization(MaConnexion)
FOR EACH Optim OF tabOptim
	AfficheInfo(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 full server optimization, the user must be a superuser.
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 group of users, use HModifyServerRights or HModifyDatabaseRights.
Component: wd300hf.dll
Minimum version required
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/24/2024

Send a report | Local help