| [Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] |
Unprepare a prepared query
Source position: sqldb.pp line 585
public procedure TCustomSQLQuery.UnPrepare; virtual; |
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.
If the SQL server cannot unprepare the statement, an exception may be raised.
|
SQL statement type |
|
|
Prepare a query for execution. |
|
|
Execute a SQL statement that does not return a result set |