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

Column mapping.

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

Column mapping.

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