Skip to content

    TPSCommandType

    Type of SQL command.

    Declaration

    Source position: db.pas line 1622

    type
  TPSCommandType = (ctUnknown,ctQuery,ctTable,ctStoredProc,ctSelect,
                  ctInsert,ctUpdate,ctDelete,ctDDL)

    Values

    Value Description
    ctUnknown Unknown SQL type or not SQL based.
    ctQuery General SQL statement.
    ctTable Table contents (select * from table).
    ctStoredProc Stored procedure statement.
    ctSelect SQL SELECT Statement.
    ctInsert SQL INSERT Statement.
    ctUpdate SQL UPDATE statement.
    ctDelete SQL DELETE Statement.
    ctDDL SQL DDL statement.

    Description

    TPSCommandType is used in the IProviderSupport.PSGetCommandType call to determine the type of SQL command that the provider is exposing. It is meaningless for datasets that are not SQL based.