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