ODAC

TCustomDASQL.Prepare Method

Allocates, opens, and parses cursor for a query.

Class

TCustomDASQL

Syntax

procedure Prepare; virtual;

Remarks

Call the Prepare method to allocate, open, and parse cursor for a query. Calling Prepare before executing a query improves application performance.

TCustomDADataSet automatically prepares a query if it is executed without being prepared first. After execution, TCustomDADataSet unprepares the query. When a query is executed a number of times, an application should always explicitly prepare the query to avoid multiple and unnecessary prepares and unprepares.

The UnPrepare method unprepares a query.

Note: When you change the text of a query at runtime, the query is automatically closed and unprepared.

See Also

© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback