Norman,

If you use Firebird 2.5, you can use this format:

execute block as
declare variable i1 integer;
declare variable i2 integer;
begin
for execute statement 'select field1, field2 from table'
on external 'server:drive:\path\dbname.fdb'
as user 'SYSDBA' password 'masterkey'
into :i1, :i2
do begin
insert into table(field1, field2) values(:i1, :i2);
end
end


[Non-text portions of this message have been removed]