hScheduleMaterializedView (Type of variable)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

WEBDEV

WINDEV Mobile

Others

See also

hScheduleMaterializedView (Type of variable)

In french: hPlanificationVueMatérialisée

The type hScheduleMaterializedView allows to manage a recalculation task of the data of a planned materialized view on a 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

// 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.Planification.Mois = "*"
refreshView.Planification.JourDeLaSemaine = "samedi"
refreshView.Planification.Time = "23"
refreshView.Planification.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 for handle a task to recalculate the data of a materialized view:

Property name	Type used	Effect

Enabled	Boolean	True if data recalculation planning is active, False otherwise.
Description	Character string	HEX@ associated with the task of recalculating the data of a materialized view.
Identifier	Integer	Identifier of the task to recalculate the data of the materialized views. This property is available in read-only.
Scheduling	hScheduling variable	Characteristics of the planning to be carried out for the recalculation of the contents of materialized views.
User	Character string	User who created the recalculation scheduling task for 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"

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.