[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] | Reference for unit 'SQLDB' (#fcl)

# TCustomSQLQuery.UnPrepare

Unprepare a prepared query

## Declaration

Source position: sqldb.pp line 585

`public procedure TCustomSQLQuery.UnPrepare; virtual;`

## Description

Unprepare will unprepare a prepared query. This means that server resources for this statement are deallocated. After a query was unprepared, any ExecSQL or Open command will prepare the SQL statement again.

Several actions will unprepare the statement: Setting the TSQLQuery.SQL property, setting the Transaction property or setting the Database property will automatically call UnPrepare. Closing the dataset will also unprepare the query.

## Errors

If the SQL server cannot unprepare the statement, an exception may be raised.

## See also

TSQLQuery.StatementType |  | SQL statement type
TCustomSQLQuery.Prepare |  | Prepare a query for execution.
TCustomSQLQuery.ExecSQL |  | Execute a SQL statement that does not return a result set