| [Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] | 
Unprepare a previously prepared statement
Source position: sqldb.pp line 410
| public procedure TCustomSQLStatement.Unprepare; | 
Unprepare unprepares a prepared SQL statement. It is called automatically when the SQL statement is changed. Depending on the database engine, it will also de-allocate any allocated resources on the database server. if the statement is not in a prepared state, nothing happens.
If an error occurs at the database level (the unprepare operation failed to execute properly) then an exception is raised.
| 
 | The SQL statement to execute | |
| 
 | Database instance to execute statement on. | |
| 
 | The transaction in which the SQL statement should be executed. | |
| 
 | Prepare the statement for execution |