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
<Connection variable>.UpdateView (Function)
In french: <Variable Connexion>.MiseAJourVue
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 <Connection variable>.RefreshView.
Example
// Describe the connection
MyConnection is Connection
 
// Updates the description of the view on the HFSQL server
MyConnection.UpdateView(MyView)
Syntax
<Result> = <Connection>.UpdateView(<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>: Connection variable
Name of the Connection variable that describes the connection to the server on which the SQL or materialized view must be created or updated.
<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 25
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/21/2023

Send a report | Local help