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-67c113c1382ec309492641/]Assign command
[crayon-67c113c1382f3094072162/]Set source result set name
[crayon-67c113c1382f5385199216/]Set the DatSTable name
Set the DatSTable name where the rows are fetched.
[crayon-67c113c1382f6906605984/]Set the UpdateTable name
[crayon-67c113c1382f8563611809/]Set the UpdateTable name
[crayon-67c113c1382f9676570654/]Setup column mappings
[crayon-67c113c1382fb544822992/]Fetch rows
[crayon-67c113c1382fc952070863/]Update changes to RDBMS
To append rows, implement the following code:
[crayon-67c113c1382fd577910627/]Then, the sample updates the changes to the RDBMS.
[crayon-67c113c1382fe530254250/]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