[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 549

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 automaticall 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: Sep 28 2017