HRefreshView (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

This content comes from an automatic translation.

Necessary rights

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HRefreshView (Function)

In french: HRafraî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".

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Example

HRefreshView(MyConnection, MyView)

Syntax

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

<Result>: Boolean

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

<Connection>: Character string (with or without quotes) or Connection variable

Connection to handle. This connection corresponds to:
or in the name of the connection defined in the analysis editor or using the HDescribeConnection or HOpenConnection functions.
the name of a Connection variable.

<View>: Character string (with quotes)

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.
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.
hNoWait The refresh of materialized view is not a locking operation: it is performed in background task. The HInfoView function allows you to know the result of the refresh of the materialized view.
Remark: This parameter is available from version 200057.

Remarks

Versions 23 and later

Necessary rights

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

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 HInfoServerRights or HInfoDatabaseRights.

To modify the rights granted to a user or to a group of users, use HModifyServerRights or HModifyDatabaseRights.

New in version 23

Necessary rights

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

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 HInfoServerRights or HInfoDatabaseRights.

To modify the rights granted to a user or to a group of users, use HModifyServerRights or HModifyDatabaseRights.

Necessary rights

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

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 HInfoServerRights or HInfoDatabaseRights.

To modify the rights granted to a user or to a group of users, use HModifyServerRights or HModifyDatabaseRights.

Component : wd250hf.dll