PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

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
HUpdateQuery (Function)
In french: HMiseAJourRequête
HFSQL Client/ServerAvailable only with this kind of connection
Warning
From version 27, HRefreshQuery is kept for backward compatibility. This function is replaced by HUpdateQuery.
Creates or updates a query on an HFSQL server. Then, the query (.WDR file) can be used in a stored procedure on the server. Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for Java applications.
New in version 22
iPhone/iPad This function is now available for iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for Java applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for Java applications.
Example
// Describe the connection
MyConnection is Connection
 
// Update or create the query
HUpdateQuery(MyConnection, Query1)
 
// Update the query even if there is a more recent version of the query on the server
HUpdateQuery(MyConnection, Query1, True)
Syntax
<Result> = HUpdateQuery(<Connection> , <Query> [, <Force>])
<Result>: Boolean
  • True if the query was created or updated,
  • False otherwise. HError is used to identify the error.
<Connection>: Character string or Connection variable
Connection to the server on which the query must be created or updated. This connection corresponds to:
<Query>: Character string
Name of the query to be created or updated on the server.
If this parameter corresponds to "*", all the queries will be updated or created on the server.
<Force>: Optional boolean
  • False (default value): the query will be created or updated:
    • if the query is not found on the server.
    • if an earlier version of the query is found on the server.
  • True: the query will be created in any case.
Business / UI classification: Business Logic
Component: wd270hf.dll
Minimum version required
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment