The Commands sample shows you how to set up column mappings.
Table of Contents
Location
You can find the MappingColumns sample project at:
- Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to:
Object PascalDatabaseFireDACSamplesDApt LayerMappingColumns
- Subversion Repository:
- You can find Delphi code samples in GitHub Repositories. Search by name into the samples repositories according to your RAD Studio version.
How to Use the Sample
- Navigate to the location given above and open
MappingColumns.dproj
. - Press F9 or choose Run > Run.
- Click on the Use Connection Definition combo box and select an option.
Files
File in Delphi | Contains |
---|---|
MappingColumns.dproj MappingColumns.dpr | The project itself. |
fMappingColumns.pas fMappingColumns.fmx | The main form. |
Implementation
To set up the columns mapping, the sample implements the following steps.
Create table adapter
[crayon-67c115f07cf55508692001/]Assign command
[crayon-67c115f07cf5b086855719/]Set source result set name
[crayon-67c115f07cf5d110989465/]Set the DatSTable name
Set the DatSTable name where the rows are fetched.
[crayon-67c115f07cf5e540026313/]Set the UpdateTable name
[crayon-67c115f07cf5f783310443/]Set the UpdateTable name
[crayon-67c115f07cf60417462142/]Setup column mappings
[crayon-67c115f07cf61758463830/]Fetch rows
[crayon-67c115f07cf62116403338/]Update changes to RDBMS
To append rows, implement the following code:
[crayon-67c115f07cf63944498019/]Then, the sample updates the changes to the RDBMS.
[crayon-67c115f07cf64816536127/]Please go to the link below if you want to check the original post of Embarcadero for this sample:
http://docwiki.embarcadero.com/CodeExamples/Sydney/en/FireDAC.MappingColumns_Sample