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 full and differential backups that have been scheduled on HFSQL Client/Server. The list of scheduled backups is returned in an array of advanced hBackupDescription variables.
Example
arrBck is dynamic array of hBackupDescription
arrBck = HListScheduledBackup(cnt)
hBck is hBackupDescription
 
FOR EACH hBck OF arrBck
Trace("_______________________________________________________")
Trace("hBck.Identifier = " + hBck.Identifier)
Trace("hBck.Description = " + hBck.Description)
Trace("hBck.Destination = " + hBck.Destination)
Trace("hBck.LimitNumberBackups = " + hBck.LimitNumberBackups)
Trace("hBck.Source = " + hBck.Source)
Trace("hBck.User = " + hBck.User)
 
Trace("hBck.SchedulingFull.Month = " + ...
hBck.SchedulingFull.Month)
Trace("hBck.SchedulingFull.DayOfMonth = " + ...
hBck.SchedulingFull.DayOfMonth)
Trace("hBck.SchedulingFull.Hour = "  + ...
hBck.SchedulingFull.Hour)
Trace("hBck.SchedulingFull.Minute = " + ...
hBck.SchedulingFull.Minute)
Trace("hBck.SchedulingFull.DayOfWeek = " + ...
hBck.SchedulingFull.DayOfWeek)
Trace("hBck.SchedulingFull.DayOfMonthOrDayOfWeek = " + ...
hBck.SchedulingFull.DayOfMonthOrDayOfWeek)
 
Trace("hBck.SchedulingDifferential.Month = " + ...
hBck.SchedulingDifferential.Month)
Trace("hBck.SchedulingDifferential.DayOfMonth = " + ...
hBck.SchedulingDifferential.DayOfMonth)
Trace("hBck.SchedulingDifferential.Hour = " + ...
hBck.SchedulingDifferential.Hour)
Trace("hBck.SchedulingDifferential.Minute = " + ...
hBck.SchedulingDifferential.Minute)
Trace("hBck.SchedulingDifferential.DayOfWeek = " + ...
hBck.SchedulingDifferential.DayOfWeek)
Trace("hBck.SchedulingDifferential.DayOfMonthOrDayOfWeek = " + ...
hBck.SchedulingDifferential.DayOfMonthOrDayOfWeek)
 
END
Syntax
<Result> = HListScheduledBackup(<Connection>)
<Result>: Array of hBackupDescription variables
Array containing the hBackupDescription variables.
<Connection>: Character string or Connection variable
Connection for which the scheduled backups must be listed. This connection corresponds to:
Remarks

Necessary rights

To list the scheduled backups, the user or the group must have:
  • for each database affected by the backup, the rights to perform backups (hRightsBackup constant) or the rights to connect (hRightsConnection or hRightsEncryptedConnection constant).
  • for a full server backup, the rights to perform backups (hRightsBackup constant) on the server.
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: 07/06/2023

Send a report | Local help