Skip to content

    TSQLTransaction.Options

    Transaction options.

    Declaration

    Source position: sqldb.pp line 363

    published property Options: TSQLTransactionOptions 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

    Name Description
    TSQLStatement Class to execute non-select SQL statements.
    TSQLQuery Class to handle SQL commands (with or without result set).