[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] | Reference for unit 'SQLDB' (#fcl)

# TSQLStatementInfo

Record to describe a SQL statement

## Declaration

Source position: sqldb.pp line 85

`type TSQLStatementInfo = record`
`StatementType: TStatementType;` |  | Type of SQL statement
`TableName: string;` |  | Tablename to be used in updates
`Updateable: Boolean;` |  | Updateable SQL result set ?
`WhereStartPos: Integer;` |  | Where clause start position
`WhereStopPos: Integer;` |  | Where clause end position
`end;`

## Description

TSQLStatementInfo is a record used to describe an SQL statement. It is used internally by the TSQLStatement and TSQLQuery objects to analyse SQL statements.

It is used to be able to modify the SQL statement (for additional filtering) or to determine the table to update when applying dataset updates to the database.

## See also

TSQLStatement |  | Class to execute non-select SQL statements.
TSQLQuery |  | Class to handle SQL commands (with or without result set)