The Commands sample shows you how to set up column mappings.
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.dprojMappingColumns.dpr | The project itself. |
fMappingColumns.pasfMappingColumns.fmx | The main form. |
Implementation
To set up the columns mapping, the sample implements the following steps.
Create table adapter
[crayon-69021f23640df879917138/]Assign command
[crayon-69021f23640e9746933272/]Set source result set name
[crayon-69021f23640eb394863918/]Set the DatSTable name
Set the DatSTable name where the rows are fetched.
[crayon-69021f23640ec872122028/]Set the UpdateTable name
[crayon-69021f23640ed149728798/]Set the UpdateTable name
[crayon-69021f23640ee821124192/]Setup column mappings
[crayon-69021f23640f0132702682/]Fetch rows
[crayon-69021f23640f1561375289/]Update changes to RDBMS
To append rows, implement the following code:
[crayon-69021f23640f2156663919/]Then, the sample updates the changes to the RDBMS.
[crayon-69021f23640f3313898660/]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

