[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 303

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

## Description

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.

## See also

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