[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index]

Reference for unit 'SQLDB' (#fcl)

TSQLQueryOption

SQL Query options

Declaration

Source position: sqldb.pp line 471

`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
`);`

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