Skip to content

TCustomSQLQuery.UnPrepare

Unprepare a prepared query.

Declaration

Source position: sqldb.pp line 622

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

Name Description
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.