<Connection variable>.RefreshView (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

Necessary rights

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Connection variable>.RefreshView (Function)

In french: <Variable Connexion>.RafraîchitVue

Available only with these kinds of connection

Asks to recalculate the content of a materialized view.

Remark: You also have the ability to refresh the view via the SQL statement "REFRESH MATERIALIZED VIEW".

Example

// Describe the connection
MyConnection is Connection

MyConnection.RefreshView(MyView)

Syntax

<Result> = <Connection>.RefreshView(<View> [, <Option>])

<Result>: Boolean

True if the materialized view was refreshed,
False if an error occurred. HErrorInfo is used to identify the error.

<Connection>: Connection variable

Name of the Connection variable that describes the connection to use.

<View>: Character string

Name of materialized view whose data must be recalculated. This view was created:
via the data model editor.
via the SQL "CREATE MATERIALIZED VIEW" command.

<Option>: Optional Integer constant

Mode for refreshing the materialized view.
hNoWait The refresh of materialized view is not a locking operation: it is performed in background task. <Connection variable>.InfoView returns the information of the materialized view after being refreshed.
Parameter not specified (by default) The refresh of materialized view is locking for the one who requested it. <Result> is used to find out the status report of refresh.

Remarks

Necessary rights

To recalculate the content of materialized view, you must have:

the corresponding rights (hRightsManageTask constant) on the server,
for each relevant database (which means containing a view to process), the rights to connect (hRightsConnection or hRightsEncryptedConnection constant).

To find out whether these rights are granted to a user or to a group, use <Connection variable>.InfoServerRights or <Connection variable>.InfoDatabaseRights.

To modify the rights granted to a user or to a group of users, use <Connection variable>.ModifyServerRights or <Connection variable>.ModifyDatabaseRights.

Component: wd280hf.dll