How do I save both master and details in a transaction so all or nothing is saved? I cant get the masters id to use as foreign key in detail before committing master data and then its too late to rollback if somehting goes wrong with saving the details?
In this test-program, add a new master (Country), then use the DBGrid to fill out the details.
The details are descriptions of predefined ItemTypes. (Capital and Language). The itemtypes are shown in the left column and supposed make it easy to understand what you are expected to fill out in the right column.
Demo creates a small SQLite database in the program dir