HPrepareQuery (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 functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HPrepareQuery (Function)

In french: HPrépareRequête

Not available with these kinds of connection

Initializes a query and declares this query to the database server in order to optimize the next executions of this query. This query is not run. Then, the query can be run by HExecuteQuery. This function is available for queries with or without bind.

To free the resources of this query, use HCancelDeclaration.

We recommend that you use this function when the same query is run successively and when only some of the query parameters are modified at each execution.

This function is optional and it can only be used on the Client/Server databases (currently available for AS/400).

For the other databases accessed by a Native Connector, OLE DB or ODBC, HPrepareSQLQuery runs the query.

This function cannot be used on the HFSQL databases (HFSQL Classic or Client/Server) and on the xBase databases.

Example

HPrepareQuery(REQ_MaReq, MaConnexion, hQueryWithoutCorrection)
FOR i = 1 TO 10
	REQ_MaReq.nom = "Nom" + i
	REQ_MaReq.prenom = "Prenom" + i
	REQ_MaReq.age_ = i
	HExecuteQuery(REQ_MaReq)
END

Syntax

<Result> = HPrepareQuery(<Query> , <Connection> [, <Mode>])

<Result>: Boolean

True if the query was initialized,
False otherwise. HErrorInfo returns more details about the problem.

<Query>: Character string

Name and full path of query (".WDR" file) to initialize.
Logical name of the query to be initialized.
If a query with the same name is already declared, it is replaced with the new query.

<Connection>: Character string or Connection variable

Connection through which the query will be run. 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.

<Mode>: Optional Integer constant

Option for initializing the query:
hQueryWithoutCorrection
No check is performed by the HFSQL engine. This option must be used if the query contains commands specific to a connection type (Oracle, SQL Server, etc.).
Warning: if this constant is used:
the connection name must be specified (<Connection> parameter).
HFilter cannot be called on the query used.
it is advisable not to specify a browse item in the following functions: HLast, HReadLast, HReadFirst, HFirst, HSeekLast, HSeekFirst.

Component: wd300hf.dll