ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / Types of HFSQL variables
  • Properties specific to 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 programmatically manage a task for recalculating the data of a scheduled materialized view on an HFSQL server.
The characteristics of this task can be defined and changed using different WLanguage properties.
Remarks:
  • For more details on materialized views, see Materialized view.
  • For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.
Example
// Refresh the materialized views every Saturday at 23:00
refreshView is hScheduleMaterializedView
refreshView.Description = "View data recalculation"
 
// Characteristics of the scheduling
refreshView.Scheduling.Month = "*"
refreshView.Scheduling.DayOfWeek = "Saturday"
refreshView.Scheduling.Hour = "23"
refreshView.Scheduling.Minute = "0"
 
// Add the materialized view to refresh
 
// Syntax 1:
// Refreshes all the materialized views of "MyDatabase"
refreshView.View[1] = "MyDatabase"
 
// Syntax 2:
// Refreshes "MyView" of "MyDatabase"
refreshView.View[1] = "MyDatabase/MyView"
 
HAddScheduling(cnt, refreshView)
Remarks

Properties specific to hScheduleMaterializedView variables

The following properties can be used to handle a task for recalculating the data of a materialized view:
Property nameType usedEffect
DescriptionCharacter stringDescription associated with the data recalculation task of a materialized view.
EnabledBoolean
  • True if the data recalculation scheduling is enabled,
  • False otherwise.
IdentifierIntegerIdentifier of the data recalculation task of materialized views.
This property is read-only.
SchedulinghScheduling variableCharacteristics of the scheduling to be established to recalculate the content of materialized views.
UserCharacter stringUser who created the materialized view recalculation scheduling task.
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.View[1] = "MyDatabase"
To refresh "MyView" of "MyDatabase", the syntax is as follows:
refreshView.View[1] = "MyDatabase/MyView"

Functions that are using the hScheduleMaterializedView variables:

HAddSchedulingCreates a scheduled task on an HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
HDeleteSchedulingDeletes a scheduled task found on an HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
HExecuteSchedulingImmediately runs a scheduled task regardless of its schedule:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
HModifySchedulingModifies 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

Last update: 01/26/2023

Send a report | Local help