Preparing a query
Go Up to Working with Queries
Preparing a query is an optional step that precedes query execution. Preparing a query submits the SQL statement and its parameters, if any, for parsing, resource allocation, and optimization. The server, too, may allocate resources for the query. These operations improve query performance, making your application faster, especially when working with updatable queries.
An application can prepare a query by calling the
Prepare method. If you do not prepare a query before executing it, then Delphi automatically prepares it for you each time you call
ExecSQL. Even though Delphi prepares queries for you, it is better programming practice to prepare a query explicitly. That way your code is self-documenting, and your intentions are clear. For example:
CustomerQuery.Close; if not (CustomerQuery.Prepared) then CustomerQuery.Prepare; CustomerQuery.Open;
This example checks the query component’s
Prepared property to determine if a query is already prepared.
Prepared is a Boolean value that is
True if a query is already prepared. If the query is not already prepared, the example calls the
Prepare method before calling