PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
  • Properties specific to the description of hScheduleMaterializedView variables
  • Functions that are using the hScheduleMaterializedView variables:
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
hScheduleMaterializedView (Type of variable)
In french: hPlanificationVueMatérialisée
The hScheduleMaterializedView type is used to manage a recalculation task of the data of a materialized view scheduled on an HFSQL server by programming.
The characteristics of this task can be defined and modified using different WLanguage properties.
Remarks:
  • For more details on materialized views, see Materialized view.
  • See Declaring a variable for more details on the declaration of this type of variable and the use of WLanguage properties.
Example
// Rafraîchir les vues matérialisées tous les samedi à 23H00
refreshView is hScheduleMaterializedView
refreshView.Description = "Recalcul des données des vues"
 
// Caractéristiques de la planification
refreshView.Scheduling.Month = "*"
refreshView.Scheduling.DayOfWeek = "samedi"
refreshView.Scheduling.Hour = "23"
refreshView.Scheduling.Minute = "0"
 
// Ajout des vues matérialisées à rafraîchir
 
// Syntaxe 1:
// Rafraîchit toutes les vues matérialisées de la base de données "MaBase"
refreshView.View[1] = "MaBase"
 
// Syntaxe 2:
// Rafraîchit la vue "MaVue" de la base de données "MaBase"
refreshView.View[1] = "MaBase/MaVue"
 
HAddScheduling(cnx, refreshView)
Remarks

Properties specific to the description of hScheduleMaterializedView variables

The following properties can be used to handle a recalculation task of the data of a materialized view:
Property nameType usedEffect
EnabledBoolean
  • True if data recalculation planning is active,
  • False otherwise.
DescriptionCharacter stringdescription associated with the task of recalculating the data of a materialized view.
IdentifierIntegerIdentifier of the task to recalculate the data of the materialized views.
This property is available in read-only mode.
SchedulinghScheduling variableCharacteristics of the planning to be carried out for the recalculation of the contents of materialized views.
UserCharacter stringUser who created the recalculation scheduling task for materialized views.
This property is read-only.
ViewArray of stringsList of materialized views whose task will recalculate the content. These views have been created: To refresh all the materialized views of "MyDatabase", the syntax is as follows:
refreshView.Vue[1] = "MaBase"
To refresh "MyView" of "MyDatabase", the syntax is as follows:
refreshView.Vue[1] = "MaBase/MaVue"

Functions that are using the hScheduleMaterializedView variables:

Versions 20 and later
HAddScheduling
New in version 20
HAddScheduling
HAddScheduling
Creates a scheduled task on an HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
Versions 20 and later
HDeleteScheduling
New in version 20
HDeleteScheduling
HDeleteScheduling
Deletes a scheduled task found on an HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
Versions 20 and later
HExecuteScheduling
New in version 20
HExecuteScheduling
HExecuteScheduling
Immediately runs a scheduled task regardless of its schedule:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
Versions 20 and later
HModifyScheduling
New in version 20
HModifyScheduling
HModifyScheduling
Modifies a scheduled task on an HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment