TSQLConnection.Options¶
Options to observe for this connection.
Declaration¶
Source position: sqldb.pp line 328
published property Options: TSQLConnectionOptions 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¶
| Name | Description |
|---|---|
| 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. |