PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
New WINDEV, WEBDEV, WINDEV Mobile 25 feature!
  • Necessary rights
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
<Connection variable>.RefreshView (Function)
In french: <Variable Connexion>.RafraîchitVue
HFSQLHFSQL Client/ServerAvailable 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
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
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 (with quotes)
Name of materialized view whose data must be recalculated. This view was created:
<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.
hNoWaitThe refresh of materialized view is not a locking operation: it is performed in background task. <Connection variable>.InfoView is used to find out the result of the refresh performed on 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 <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.
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 <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.

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 <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 : wd250hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment