At 07:33 PM 18/12/2004 +0100, you wrote:

>Hello!
>
>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". 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.

./hb