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-672a759f82160956037996/]Selecting data
[crayon-672a759f82169864313712/]Redirect records
Redirect all record inserts into FDQA_map2 table instead FDQA_map1:
[crayon-672a759f8216b120272757/]Redirect all record deletes into FDQA_map3 table instead FDQA_map1:
[crayon-672a759f8216d786789904/]Redirect all record updates into FDQA_map4 table instead FDQA_map1:
[crayon-672a759f8216e491507714/]Add new rows
[crayon-672a759f82170091974151/]Post changes to RDBMS
[crayon-672a759f82173368515703/]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