At 08:05 PM 27/11/2008, you wrote:

>Hello all,
>
>i'm using IB Objects Components and now i want to do same things with
>the TIB_DATAPUMP.
>
>I have read all the posts according to this component but still i
>won't get it works for me.
>
>I use the delphi demo Datapump_demo from the files of this group.
>
>I have 2 databases - same Table structure.
>DB1 is the source, DB2 the dest.
>
>For reading the source i use the tib_cursor, for writing the tib_dsql.
>
>my source statement= 'SELECT * FROM TAB'
>my destination statement= 'insert into TAB SELECT * FROM TAB'
>
>after commiting my dest table ist still empty.
>so i try the rename my dest tabel to tab1
>
>my source statement= 'SELECT * FROM TAB'
>my destination statement= 'insert into TAB1 SELECT * FROM TAB'
>
>But now i get an error, because my tib_sql don't now the table "tab".
>
>I tried everything without success.
>
>So what do i wrong?

Be prepared to do a little more typing! This way will bind the source output data directly to the target input parameters:

From the source database (use a tib_cursor for the SrcDataset object and don't forget to prepare it before you begin)
select Col1, Col2, etc (all the columns you want)
from tab

To the target database (use a tib_dsql for this and don't forget to prepare it either!)
insert into tab1 (
Col1, Col2, etc (all the same columns)
values (:Col1, :Col2, :etc.....)

And do read the help file.

Helen