Skip to content

    TSQLQueryOption

    SQL Query options.

    Declaration

    Source position: sqldb.pp line 488

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

    Values

    Value Description
    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

    Name Description
    TSQLQueryOptions Set of TSQLQueryOption.