Sign in Join
FPDoc Onlineexperiment

TSQLQueryOption enumeration

In unit SQLDB

SQL Query options.

Declaration

pascal
TSQLQueryOption = (sqoKeepOpenOnCommit,sqoAutoApplyUpdates,
 sqoAutoCommit,sqoCancelUpdatesOnRefresh,
 sqoRefreshUsingSelect,sqoNoCloseOnSQLChange)

Description

TSQLQueryOption enumerates several options available to control the behaviour of an TSQLQuery instance.

See also

Values

sqoKeepOpenOnCommitKeep the dataset open after the query was committed (will fetch all records).
sqoAutoApplyUpdatesCall ApplyUpdates on Post or Delete.
sqoAutoCommitCall commit after every ApplyUpdates or ExecSQL.
sqoCancelUpdatesOnRefreshCancel any pending updates when refresh is called.
sqoRefreshUsingSelectForce a refresh using the provided select instead of using RETURNING clause.
sqoNoCloseOnSQLChange

An experiment, built from development snapshots. Not the official Free Pascal or Lazarus documentation.