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

Reference for unit 'SQLDB' (#fcl)

TSQLConnection.Options

Options to observe for this connection.

Declaration

Source position: sqldb.pp line 302

published property TSQLConnection.Options : TSQLConnectionOptions read FOptions write SetOptions default [];

Options can be used to control the behaviour of SQLDB for this connection. The following options can be set:

scoExplicitConnect: When set, the connection must be explicitly made. Default behaviour is for TSQLQuery to implicitly open the connection as needed.
scoApplyUpdatesChecksRowsAffected: When set, whenever an update SQL Statement is executed during ApplyOptions of a dataset, the RowsAffected is checked and must be equal to 1.

TCustomSQLQuery.ApplyUpdates		Apply updates and check result
TCustomSQLStatement.RowsAffected		Number of rows affected by the SQL statement.
TCustomSQLQuery.RowsAffected		Return the number of rows (records) affected by the last DML/DDL statement