> >I have two fdb files, file1.fdb and file2.fdb.
> >I want to copy some records (not whole table) from Table_a from
> file2.fdb to
> >Table_a from file1.fdb.
> >
> >Table_a in both fdb files has the same structure.
> >
> >How can I do this ?
>
> Not with a dynamic SQL statement. You need an application that reads
> (queries) the data from one database and writes it to the other using an
> update or insert statement. The operation is known as "pumping data" or
> "datapump".

Thanks Helen.
Does that mean, that after getting data from first fdb file, I should store
somewhere, and then pass this values to insert statement for second
database.
This is clear to me until I want to pump blob fields with this method. How
should blob fields be handeled ?

>There are lots of such utility tools around, (components too,
> if you are using Delphi or BCCPPB) or you can roll your own, preferably
> using a cross-database transaction to keep the source and
> destination data consistent with one another.

I'll look for components (using BCB6, do you have any good one in mind ?),
but I'm also interested in my own function.
Where can I find more data about cross-database transaction? Looking through
your book, but haven't found it. Sorry if I missed it.

Regards,
Primoz