|
|
|
|
|
|
|
|
HUpdateQuery (Function) In french: HMiseAJourRequête
 Available 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.
// 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
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|