Unit 'SQLDB' Package
[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] [#fcl]

TCustomSQLQuery.UnPrepare

Unprepare a prepared query.

Declaration

Source position: sqldb.pp line 604

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.


Documentation generated on: Nov 23 2024