Skip to content

    TSQLTransaction.Rollback

    Roll back all changes made in the current transaction.

    Declaration

    Source position: sqldb.pp line 353

    public 
procedure TSQLTransaction.Rollback;  override;

    Description

    Rollback undoes all changes in the database since the start of the transaction. It can only be executed in an active transaction.

    After this, the transaction is no longer active. To undo changes but keep an active transaction, execute RollbackRetaining instead.

    Remark:

    Changes posted in datasets that are coupled to this transaction will not be undone in memory: these datasets must be reloaded from the database (using Close and Open to reload the data as it is in the database.

    Errors

    Executing Rollback when no transaction is active will result in an exception. A transaction must be started by calling StartTransaction. If the database backend reports an error, an exception is raised as well.

    See also

    Name Description
    StartTransaction Start a new transaction.
    CommitRetaining Commit the transaction, retain transaction context.
    Commit Commit the transaction, end transaction context.
    RollbackRetaining Roll back changes made in the transaction, keep transaction context.