PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
hScheduleMaterializedView (Type of variable)
In French: hPlanificationVueMatérialisée
The hScheduleMaterializedView type is used to manage a task for re-calculating the data of a scheduled materialized view on a HFSQL server by programming.
The characteristics of this task can be defined and modified by several WLanguage properties.
Notes:
Example
// Refresh the materialized views every Saturday at 23:00
refreshView is hScheduleMaterializedView
refreshView..Description = "Recalculating the data of the views"

// 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 the description of hScheduleMaterializedView variables

The following properties can be used to handle a task for re-calculating the data of a materialized view:
Property nameType usedEffect
Enabled
(available from version 200057)
Boolean
  • True if the scheduling for re-calculating data is enabled,
  • False otherwise.
DescriptionCharacter stringDescription associated with the task for re-calculating the data of a materialized view.
IdentifierIntegerIdentifier of the task for re-calculating data in the materialized views.
This property is available in read-only.
SchedulinghScheduling variableCharacteristics of the scheduling to perform for re-calculating the content of the materialized views.
User
(available from version 200057)
Character stringUser who created the task for scheduling the re-calculation of 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.View[1] = "MyDatabase"
To refresh "MyView" of "MyDatabase", the syntax is as follows:
refreshView.View[1] = "MyDatabase/MyView"
Note: These properties can be used with one of the following syntaxes:
  • <Variable Name>..<Property Name>
  • <Variable Name>.<Property Name>

Functions that are using the hScheduleMaterializedView variables:

Versions 20 and later
HAddScheduling
New in version 20
HAddScheduling
HAddScheduling
Creates a scheduled task on a HFSQL server
  • stored procedure,
  • backup,
  • optimization,
  • refresh of a materialized view.
Versions 20 and later
HDeleteScheduling
New in version 20
HDeleteScheduling
HDeleteScheduling
Deletes a scheduled task found on a HFSQL server
  • stored procedure,
  • backup,
  • optimization,
  • refresh of a 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 a HFSQL server
  • stored procedure,
  • backup,
  • optimization,
  • refresh of a materialized view.
Minimum required version
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment