hScheduleMaterializedView (Type of variable)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Properties specific to the description of hScheduleMaterializedView variables
Functions that are using the hScheduleMaterializedView variables:

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

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.

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

// 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 name	Type used	Effect

Enabled	Boolean	True if the scheduling for re-calculating data is enabled, False otherwise.
Description	Character string	Description associated with the task for re-calculating the data of a materialized view.
Identifier	Integer	Identifier of the task for re-calculating data in the materialized views. This property is available in read-only.
Scheduling	hScheduling variable	Characteristics of the scheduling to perform for re-calculating the content of the materialized views.
User	Character string	User who created the task for scheduling the re-calculation of materialized views. This property is read-only.
View	Array of strings	List of materialized views whose task will recalculate the content. These views have been created: in the data model editor, via the SQL "CREATE MATERIALIZED VIEW" command. 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"

Remark: 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 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 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.