Skip to content

    TSQLParseOption

    Represents SQL parser options available to the TParams collection.

    Declaration

    Source position: db.pas line 1522

    type
  TSQLParseOption = (spoCreate,spoEscapeSlash,spoEscapeRepeat,spoUseMacro)

    Values

    Value Description
    spoCreate Indicates existing parameters are cleared and re-created, not updated.
    spoEscapeSlash Causes the Slash character ('/') to be escaped.
    spoEscapeRepeat Causes an escaped character to be repeated.
    spoUseMacro Enables macro expansion in a SQL statement.

    Description

    TSQLParseOption is an enumerated type with values that represent SQL parser options available for use in the TParams collection. Value(s) from TSQLParseOption are stored in the TSQLParseOptions set type, and passed as an argument to the TParams.ParseSQL method. When a value from the enumeration is included in the set, the feature or behavior is enabled while parsing the SQL statement.

    See also

    Name Description
    TParams.ParseSQL Parse SQL statement, replacing parameter names with SQL parameter placeholders.
    TSQLParseOptions Set type used to store value(s) from the TSQLParseOption enumeration.