This sample shows how to redirect inserting, deleting and updating records using standalone table adapter.
Table of Contents
Location
You can find the Commands sample project at:
- Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to:
Object PascalDatabaseFireDACSamplesDApt LayerCommands
- Subversion Repository:
- You can find Delphi code samples in GitHub Repositories. Search by name into the samples repositories according to your RAD Studio version.
Files
File in Delphi | Contains |
---|---|
Commands.dproj Commands.dpr | The project itself. |
fCommands.pas fCommands.fmx | The main form. |
Implementation
The sample implements the following standalone table adapter features.
Create table adapter
[crayon-676c7e2697115917988563/]Selecting data
[crayon-676c7e269711e322571309/]Redirect records
Redirect all record inserts into FDQA_map2 table instead FDQA_map1:
[crayon-676c7e269711f322993039/]Redirect all record deletes into FDQA_map3 table instead FDQA_map1:
[crayon-676c7e2697120135897648/]Redirect all record updates into FDQA_map4 table instead FDQA_map1:
[crayon-676c7e2697121590323578/]Add new rows
[crayon-676c7e2697122474350619/]Post changes to RDBMS
[crayon-676c7e2697124404355950/]For more details and links to other posts, you can refer to the link below:
http://docwiki.embarcadero.com/CodeExamples/Sydney/en/FireDAC.DAptLayerCommands_Sample