[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index]

Reference for unit 'sqldb' (#fcl)

TSQLTransaction.Options

Transaction options

Declaration

Source position: sqldb.pp line 343

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

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.

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