Unpreparing a query to release resources

Go Up to Working with Queries

The UnPrepare method sets the Prepared property to False. UnPrepare

• Ensures that the SQL property is prepared prior to executing it again.
• Notifies the server to release any resources it has allocated for the statement.

To unprepare a query, call

CustomerQuery.UnPrepare;

When you change the text of the SQL property for a query, the query component automatically closes and unprepares the query.

Advance To:

• Improving query performance