Unpreparing a query to release resources
Go Up to Working with Queries
The UnPrepare method sets the Prepared property to False.
- 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
When you change the text of the
SQL property for a query, the query component automatically closes and unprepares the query.