Subject Insert/Select with 2 different databases (same structure)?
Author ronald_greven
Hi there,

I use Delphi 5, Firebird 1.0 / 1.5 (both), and IB_Objects.

There is the following problem :

I have to insert Data in Database1, Table1 from Database2, Table1.
Both have the same structure.

Is there a possibility to make a sql like :
insert into Table1
select * from Table1(other Database)??

The way I do now is really circuitous :
1. I do a Loop to create a insert SQL
2. I do a Loop to set the paramlist with the values from the other
Database

But I need to speed up this procedure..

Best greetings..

Ronni