ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
HUpdateView (Function)
In french: HMiseAJourVue
HFSQL Client/ServerAvailable only with this kind of connection
Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server.
Remark: The data in the view is refreshed by HRefreshView.
Example
// Updates the description of the view on the HFSQL server
HUpdateView(MyConnection, MyView)
Syntax
<Result> = HUpdateView(<Connection> , <View> [, <Force>])
<Result>: Boolean
  • True if the SQL or materialized view was created or updated.
  • False if a problem occurs. HError is used to identify the error.
<Connection>: Character string or Connection variable
Connection to the server on which the SQL or materialized view must be created or updated. This connection corresponds to:
<View>: Character string
Name of the SQL or materialized view to use. This view must be created or updated on the HFSQL server.
<Force>: Optional boolean
  • False (default value): the view will be created or updated:
    • if the view is found on the server.
    • if an earlier version of the view is found on the server.
  • True: the view will be updated in any case.
Component: wd290hf.dll
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help