PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • 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
Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 22
iPhone/iPad This function is now available for the iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Example
MyConnection is Connection
...
arrOptim is array of hScheduledOptimization
arrOptim = HListScheduledOptimization(MyConnection)
FOR EACH Optim OF arrOptim
DisplayInfo(Optim)
END
Syntax
<Result> = HListScheduledOptimization(<Connection Name>)
<Result>: Array of hScheduledOptimization variables
Name of 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 Name>: Character string (with or without quotes)
Name of connection for which the scheduled optimization tasks must be listed. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.
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 HInfoServerRights or HInfoDatabaseRights.
To modify the rights granted to a user or to a group of users, use HModifyServerRights or HModifyDatabaseRights.
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 HInfoServerRights or HInfoDatabaseRights.
To modify the rights granted to a user or to a group of users, use HModifyServerRights or HModifyDatabaseRights.

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