Skip to content

TStatementType

Type describing the kind of SQL statement.

Declaration

Source position: sqltypes.pp line 36

type
  TStatementType = (stUnknown,stSelect,stInsert,stUpdate,stDelete,stDDL,
                  stGetSegment,stPutSegment,stExecProcedure,
                  stStartTrans,stCommit,stRollback,stSelectForUpd)

Values

Value Description
stUnknown The statement type could not be detected.
stSelect The statement is a SQL SELECT statement.
stInsert The statement is a SQL INSERT statement.
stUpdate The statement is a SQL UPDATE statement.
stDelete The statement is a SQL DELETE statement.
stDDL The statement is a SQL DDL (Data Definition Language) statement.
stGetSegment The statement is a SQL get segment statement.
stPutSegment The statement is a SQL put segment statement.
stExecProcedure The statement executes a stored procedure.
stStartTrans The statement starts a transaction.
stCommit The statement commits a transaction.
stRollback The statement rolls back a transaction.
stSelectForUpd The statement selects data for update.

Description

TStatementType describes the kind of SQL statement that was entered in the SQL property of a TSQLQuery component.

See also

Name Description
TSQLQuery Class to handle SQL commands (with or without result set).