PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

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
<Connection variable>.DeleteScheduling (Function)
In french: <Variable Connexion>.SupprimePlanification
HFSQL Client/ServerAvailable only with this kind of connection
Deletes a scheduled task found on an HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
Versions 22 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 22
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Example
cnxMaBase est une Connexion
 
// Suppression de toutes les sauvegardes planifiées
tabDescSvg est un tableau dynamique de hDescriptionSauvegarde
tabDescSvg = cnxMaBase.ListePlanification(hlpSauvegarde)
hDescSvg est une hDescriptionSauvegarde
POUR TOUT hDescSvg DE tabDescSvg
SI Position(hDescSvg.Source, cnxMaBase.BaseDeDonnées, 0, SansCasse) > 0 ALORS
cnxMaBase.SupprimePlanification(hDescSvg)
FIN
FIN
Syntax

Deleting a scheduled task Hide the details

<Result> = <Connection>.DeleteScheduling(<Scheduled task>)
<Result>: Boolean
  • True if the scheduled task was deleted,
  • False if an error occurred. HErrorInfo is used to identify the error.
<Connection>: Connection variable
Name of the Connection variable that describes the connection for which a scheduled task must be deleted.
<Scheduled task>: hScheduledTask variable
Name of hScheduledTask variable describing the task that triggers a stored procedure.

Deleting a scheduled optimization task Hide the details

<Result> = <Connection>.DeleteScheduling(<Scheduled optimization task>)
<Result>: Boolean
  • True if the scheduled optimization task was deleted,
  • False if an error occurred. HErrorInfo is used to identify the error.
<Connection>: Connection variable
Name of the Connection variable that describes the connection for which a scheduled optimization task must be deleted.
<Scheduled optimization task>: hScheduledOptimization variable
Name of the Variable of type hScheduledOptimization handled.

Deleting a backup scheduling Hide the details

<Result> = <Connection>.DeleteScheduling(<Scheduled backup>)
<Result>: Boolean
  • True if the scheduled backup was deleted,
  • False otherwise.
<Connection>: Connection variable
Name of the Connection variable that describes the connection for which a scheduled backup must be deleted.
<Scheduled backup>: hBackupDescription variable
Name of the Variable of type hBackupDescription handled.

Deleting a scheduling for refreshing a materialized view Hide the details

<Result> = <Connection>.DeleteScheduling(<Materialized view>)
<Result>: Boolean
  • True if the scheduling has been deleted,
  • False otherwise.
<Connection>: Connection variable
Name of the Connection variable that describes the connection for which a materialized view refresh scheduling must be deleted.
<Materialized view>: hScheduleMaterializedView variable
Name of the hScheduleMaterializedView variable containing the description of the materialized views to refresh.
Component: wd270hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment