Unit 'SQLDB' Package
[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] [#fcl]

TSQLQueryOption

SQL Query options

Declaration

Source position: sqldb.pp line 479

type TSQLQueryOption = (

  sqoKeepOpenOnCommit,

  

Keep the dataset open after the query was committed (will fetch all records).

  sqoAutoApplyUpdates,

  

Call ApplyUpdates on Post or Delete

  sqoAutoCommit,

  

Call commit after every ApplyUpdates or ExecSQL

  sqoCancelUpdatesOnRefresh,

  

Cancel any pending updates when refresh is called

  sqoRefreshUsingSelect,

  

Force a refresh using the provided select instead of using RETURNING clause

  sqoNoCloseOnSQLChange

);

Description

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

See also

TSQLQueryOptions

  

Set of TSQLQueryOption


Documentation generated on: Jun 05 2026