EPUB | CHM | PDF

TPSQLDatabase.Methods.Savepoint

Top Previous Next

Establishes a new savepoint within the current transaction.

Syntax:

procedure Savepoint(const Name: string);

Description:

A savepoint is a special mark inside a transaction that allows all commands that are executed after it was established to be rolled back, restoring the transaction state to what it was at the time of the savepoint.

Savepoints can only be established when inside a transaction block. There can be multiple savepoints defined within a transaction.

See also: RollbackToSavepoint, ReleaseSavepoint