At 07:12 PM 6/07/2006, you wrote:

>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..

Use a TIB_Datapump. Try out how it works in IB_SQL. It's lightning
fast and, what's more, you've got total control over what happens
between the select on the source DB and the insert into the target DB.

Helen