Subject | Insert/Select with 2 different databases (same structure)? |
---|---|
Author | ronald_greven |
Post date | 2006-07-06T09:12:49Z |
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
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