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 scheduled elements defined on an HFSQL server: scheduled tasks (stored procedure), backup, optimization, refresh of a materialized view.
Example
// Modification de toutes les sauvegardes planifiées
tabDescSvg is array dynamic of hBackupDescription 
tabDescSvg = HListScheduling(MaConnexionBase, hlpBackup)
hDescSvg is hBackupDescription
FOR EACH hDescSvg OF tabDescSvg
	IF hDescSvg.LimitNumberBackups = 3 THEN 
		hDescSvg.LimitNumberBackups = 5
		HModifyScheduling(MaConnexionBase, hDescSvg)
	END
END
Syntax
<Result> = HListScheduling(<Connection> , <Type of scheduling>)
<Result>: Array
Array containing the listed descriptions. The type of the array elements depends on <Type of scheduling>.
<Connection>: Character string or Connection variable
Connection to use. This connection corresponds to:
<Type of scheduling>: Integer constant
Type of scheduling to list:
hlpBackupScheduling of backups.
hlpMaterializedViewTasks for refreshing the materialized views.
hlpOptimizationTasks for optimizing data files (reindexing, calculation of statistics).
hlpTaskScheduled tasks that run a stored procedure.
Remarks

Necessary rights

To list the tasks for refreshing materialized views or scheduled tasks, it is necessary to have the connection rights (constant hRightsConnection or hRightsEncryptedConnection) for each database that contains a view to process or a stored procedure to run.
To find out whether these rights are granted to a user or 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 20
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/12/2025

Send a report | Local help