[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] Reference for unit 'SQLDB' (#fcl)


Options controlling the behaviour of the dataset


Source position: sqldb.pp line 703

published property TSQLQuery.Options : TSQLQueryOptions;


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

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.
Setting this option will make TSQLQuery call ApplyUpdates after every Post or Delete operation.
Setting this option will make TSQLQuery call commit after every ApplyUpdates
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
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 TSQLQuery.RefreshSQL property or a constructed refresh SQL statement.

See also



Apply updates and check result



Post pending changes and optionally apply updates



Delete and optionally apply updates

Documentation generated on: May 14 2021