TDAColumnMapping
From RemObjects Software
This is a Data Abstract Architecture entry
Feel free to add your notes to this topic below.
Overview
The TDAColumnMapping class represents an individual column mapping for a specific statement.
Column mappings are used to to map fields defined for a data table to specific field names in the back-end database, allowing one data table definition to be the front-end for different database tables.
File
uDAInterfaces
Declaration
TDAColumnMapping = class(TInterfacedCollectionItem);
Hierarchy
- TInterfacedCollectionItem
- TDAColumnMapping
Properties
| | | |
|---|---|---|
| DatasetField | String | The data table field to which this mapping pertains. |
| SQLOrigin | String | The name of the database column where the data for this field originates. In most cases, this will be identical to the field's name, unless the field was manually renamed or the original query for the data table uses the SQL "AS" keyword to rename fields, such as
SELECT Name AS UserName FROM ... In the case above, SQLOrigin would be "UserName" while the TableField would be "Name". The SQLOrigin property will be used to locate the right field in the recordset retrieved from the server, so it must match the output column name in the SELECT statement. |
| TableField | String | The name of the recordset column containing the data for this field.
In most cases, this will be identical to the field's Name, unless the field was manually renamed or the original query for the data table uses the SQL "AS" keyword to rename fields, such as SELECT Name AS UserName FROM ... In the above case, TableField would be "Name" while the SQLOrigin would be "UserName". The TableField property will be used as field-name in auto-generated INSERT, UPDATE and DELETE statements, as well as in SELECT statements generated by AutoSQL or Dynamic Where, so it must match the physical column in the data table. |
See Also
Product: RemObjects Data Abstract
Current version: Data Abstract 'Vinci' (5.0)
Lists — Glossary — Features — How To — Drivers — Components — Tools — Samples — Articles — Architecture — Issues
Categories: Text | Data Abstract | Architecture | Class | Delphi
