|
|
|
|
<Source>.PrepareQuery (Function) In french: <Source>.Pré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 <Source>.ExecuteQuery. This function is available for queries with or without bind. 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). This function cannot be used on the HFSQL databases (HFSQL Classic or Client/Server) and on the xBase databases.
QRY_MyQry.PrepareQuery(MyConnection, hQueryWithoutCorrection) Â FOR I = 1 TO 10 QRY_MyQry.lastname = "LastName" + I QRY_MyQry.firstname = "FirstName" + I QRY_MyQry.age_ = I QRY_MyQry.ExecuteQuery() END
Syntax
<Result> = <Source>.PrepareQuery(<Connection> [, <Mode>])
<Result>: Boolean - True if the query was initialized,
- False otherwise. HErrorInfo returns more details about the problem.
<Source>: Type corresponding to the specified source Logical name of the query to be initialized. If a query with the same name is already declared, it is replaced by the new query. <Connection>: Character string Connection through which the query will be run. This connection corresponds to: <Mode>: Optional Integer constant Option for initializing the query:
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|