RAD Studio |  |

Preparing Queries
See Also
Collapse All

Preparing a query is an optional step that precedes query execution. Preparing a query submits the SQL statement and its parameters, if any, to the data access layer and the database server for parsing, resource allocation, and optimization. In some datasets, the dataset may perform additional setup operations when preparing the query. These operations improve query performance, making your application faster, especially when working with updatable queries.

An application can prepare a query by setting the Prepared property to True. If you do not prepare a query before executing it, the dataset automatically prepares it for you each time you call Open or ExecSQL. Even though the dataset prepares queries for you, you can improve performance by explicitly preparing the dataset before you open it the first time.

Copy Code

    CustQuery.Prepared := True;

Copy Code

    CustQuery->Prepared = true;

When you explicitly prepare the dataset, the resources allocated for executing the statement are not freed until you set Prepared to False.

Set the Prepared property to False if you want to ensure that the dataset is re-prepared before it executes (for example, if you add a parameter).

Note: When you change the text of the SQL property for a query, the dataset automatically closes and unprepares the query.
See Also

Specifying the Query

Using Parameters in Queries

Establishing Master/detail Relationships Using Parameters

Executing Queries That Don't Return a Result Set

Using Unidirectional Result Sets

Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!