Skip to content

    TSQLTransaction.CommitRetaining

    Commit the transaction, retain transaction context.

    Declaration

    Source position: sqldb.pp line 352

    public 
procedure TSQLTransaction.CommitRetaining;  override;

    Description

    CommitRetaining commits an active transaction. The changes will be irreversibly written to the database.

    After this, the transaction is still active. To commit data and deactivate the transaction, execute Commit instead.

    Errors

    Executing CommitRetaining 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.
    Retaining Commit the transaction, end transaction context.
    Rollback Roll back all changes made in the current transaction.
    RollbackRetaining Roll back changes made in the transaction, keep transaction context.