TSQLTransaction.Options property

Declaration

property Options: TSQLTransactionOptions read FOptions write SetOptions default [];

Description

Options can be used to control the behaviour of SQLDB for this transaction.

stoUseImplicit

Use the implicit transaction support of the DB engine. This means that no explicit transaction start and stop commands will be sent to the server when the Commit or Rollback methods are called (effectively making them a no-op at the DB level).

stoExplicitStart

When set, whenever an SQL statement is executed, the transaction must have been started explicitly. Default behaviour is that the TSQLStatement or TSQLQuery start the transaction as needed.

See also

• TSQLStatement
• TSQLQuery