ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Necessary rights
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
HRefreshView (Function)
In french: HRafraîchitVue
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
Asks to recalculate the content of a materialized view.
Remark: You can also update the materialized view using SQL statement "REFRESH MATERIALIZED VIEW"..
Example
HRefreshView(MaConnexion, MaVue)
Syntax
<Result> = HRefreshView(<Connection> , <View> [, <Option>])
<Result>: Boolean
  • True if the materialized view was refreshed,
  • False if an error occurs. HErrorInfo is used to identify the error.
<Connection>: Character string or Connection variable
Connection to use. This connection corresponds to:
<View>: Character string
Name of materialized view whose data must be recalculated. This view was created:
<Option>: Optional Integer constant
Mode for refreshing the materialized view.
hNoWaitRefreshing the materialized view is not blocking: it takes place in the background. HInfoView 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 HInfoServerRights or HInfoDatabaseRights.
To modify the rights granted to a user or group of users, use HModifyServerRights or HModifyDatabaseRights.
Component: wd300hf.dll
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help