TDAJoinCondition
Overview
The TDAJoinCondition class stores conditions for JOIN
statements of the TDAJoinSourceTable. This class is used by the descendants of the TDAQueryBuilder class to generate proper SQL JOIN
statements for SELECT
queries. For example: The TDASQL92QueryBuilder uses this class to build SQL statements according to the SQL-92 standart.
You can use this class to manually to specify JOIN
conditions of the data table.
Location
- Unit: uDACore.pas
- Ancestry: TCollectionItem | TDAJoinCondition
Properties
FromFieldName
Represents the name of the field in the left part of the JOIN
statement.
property FromFieldName: string read write
FromTableName
Represents the name of the table in the left part of the JOIN
statement.
property FromTableName: string read write
ToFieldName
Represents the name of the field in the right part of the JOIN
statement.
property ToFieldName: string read write
ToTableName
Represents the name of the table in the right part of the JOIN
statement.
property ToTableName: string read write
- SQL-92 on Wikipedia
- TDAJoinSourceTable
- TDAJoinDataTable