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

TSQLQueryOptions

Set of TSQLQueryOption.

Declaration

Source position: sqldb.pp line 477

type TSQLQueryOptions = set of (

  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.

);

Description

TSQLQueryOptions is the type of the TSQLQuery.Options property.

See also

TSQLQueryOption

  

SQL Query options.

TSQLQuery.Options

  

Options controlling the behaviour of the dataset.


Documentation generated on: Jul 24 2023