Skip to content

    TCustomSQLStatement.Unprepare

    Unprepare a previously prepared statement.

    Declaration

    Source position: sqldb.pp line 442

    public 
procedure TCustomSQLStatement.Unprepare;

    Description

    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.

    Errors

    If an error occurs at the database level (the unprepare operation failed to execute properly) then an exception is raised.

    See also

    Name Description
    TSQLStatement.SQL The SQL statement to execute.
    TSQLStatement.Database Database instance to execute statement on.
    TSQLStatement.Transaction The transaction in which the SQL statement should be executed.
    TCustomSQLStatement.Prepare Prepare the statement for execution.