Hello
1) Have a look at TMemDataset or TBufDataset,
TMemDataset has the ability to copy from another
dataset fielddefs and data.
2) I've done something like that, only with SQLite3 db,
the sql is very simple and should run on Firebird.
Source code is enclosed in "transfer.zip", have a look at the TLiteDb <-> Bom_HK <-> lfm_main connections.
- ReadDb
- UpdateDb
You can pick'n'choose in the code, it may help as point to start....
Regards Benny