TSQLQuery.Options property

Member of TSQLQuerypublishedIn unit SQLDB

Options controlling the behaviour of the dataset.

Declaration

pascal

property Options:;

Options controls the behaviour of the dataset. The following options can be specified:

sqoKeepOpenOnCommit: The default SQLDB behaviour is to close all datasets connected to a transaction when a transaction is committed or rolled back, which means that transactions must remain active as long as the dataset is open. This can create problems with locking of records etc. With this option set, the dataset will be kept open. Note that setting this option will cause SQLDB to fetch all records in the result set in memory.
sqoAutoApplyUpdates: Setting this option will make TSQLQuery call ApplyUpdates after every Post or Delete operation.
sqoAutoCommit: Setting this option will make TSQLQuery call commit after every ApplyUpdates
sqoCancelUpdatesOnRefresh: Setting this option will cause TSQLQuery to abandon all pending changes when Refresh is called. The default behaviour is to raise an exception when Refresh is called and there are pending changes
sqoPreferRefresh: If the database engine supports RETURNING, then the returning mechanism is used to fetch field values after an update of the database. Setting this option will disable the use of RETURNING and will fetch updated or new values instead with the RefreshSQL property or a constructed refresh SQL statement.