TDAStatement
Overview
The TDAStatement class represents an individual statement defined for a command or data table in a schema.
Each command or data table can provide one or more separate statements, allowing for different SQL to be executed for different databases or database systems.
You will usually not create instances of this class directly, but define data tables in Schema Modeler or access them through the Statements property of the TDASQLCommand or TDADataset classes.
Location
- Unit: uDASchemaClasses.pas
- Ancestry: TCollectionItem | TDAStatement
constructor Create override
Creates a new instance.
constructor Create(Collection: TCollection)
Parameters:
- Collection: owner collection.
Assign override
Copies data from a given source.
procedure Assign(aSource: TPersistent)
Parameters:
- aSource: Instance whose properties will be copied
ColumnMappings
property ColumnMappings: TDAColumnMappingCollection read write
Connection
Connection name
property Connection: string read write
ConnectionType
Holds the connection type.
property ConnectionType: string read write
Default
Specifies whether this statement will be used by default.
property Default: Boolean read write
GeneratorName
Specifies the name of the generator in the back-end database that will be used to generate new primary key values.
property GeneratorName: string read write
GetDisplayName protected override
Returns the name of the statement as it appears in the collection editor.
function GetDisplayName: string
Name
Returns a human-readable name for the statement.
property Name: string read write
NeedsParams
Specifies if parameters are present in SQL statement
property NeedsParams: Boolean read
SQL
Defines the SQL statement
property SQL: string read write
StatementCollection
property StatementCollection: TDAStatementCollection read
StatementType
property StatementType: TDASQLStatementType read write
TargetTable
Specifies the target table.
property TargetTable: string read write
ColumnMappings
property ColumnMappings: TDAColumnMappingCollection read write
Connection
Connection name
property Connection: string read write
ConnectionType
Holds the connection type.
property ConnectionType: string read write
Default
Specifies whether this statement will be used by default.
property Default: Boolean read write
GeneratorName
Specifies the name of the generator in the back-end database that will be used to generate new primary key values.
property GeneratorName: string read write
Name
Returns a human-readable name for the statement.
property Name: string read write
NeedsParams
Specifies if parameters are present in SQL statement
property NeedsParams: Boolean read
SQL
Defines the SQL statement
property SQL: string read write
StatementCollection
property StatementCollection: TDAStatementCollection read
StatementType
property StatementType: TDASQLStatementType read write
TargetTable
Specifies the target table.
property TargetTable: string read write
constructor Create override
Creates a new instance.
constructor Create(Collection: TCollection)
Parameters:
- Collection: owner collection.
Assign override
Copies data from a given source.
procedure Assign(aSource: TPersistent)
Parameters:
- aSource: Instance whose properties will be copied
GetDisplayName protected override
Returns the name of the statement as it appears in the collection editor.
function GetDisplayName: string