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-6742c54e9076c397858357/]Selecting data
[crayon-6742c54e90772514409352/]Redirect records
Redirect all record inserts into FDQA_map2 table instead FDQA_map1:
[crayon-6742c54e90774632155888/]Redirect all record deletes into FDQA_map3 table instead FDQA_map1:
[crayon-6742c54e90775128257406/]Redirect all record updates into FDQA_map4 table instead FDQA_map1:
[crayon-6742c54e90776156097963/]Add new rows
[crayon-6742c54e90777791855225/]Post changes to RDBMS
[crayon-6742c54e90778642368937/]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