HUpdateQuery (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

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 has been replaced with 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.

Example

// Description de la connexion
MaConnexion is Connection

// Mettre à jour ou créer la requête
HUpdateQuery(MaConnexion, Requête1)

// Mettre à jour la requête même si le serveur possède une version plus récente de la requête
HUpdateQuery(MaConnexion, Requête1, 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:
the name of the connection defined in the data model editor or with HDescribeConnection or HOpenConnection.
the name of a variable of type Connection.

<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): 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 updated in all cases.

Business / UI classification: Business Logic

Component: wd300hf.dll