--- In IBObjects@yahoogroups.com, "saschaschilberz"
<saschaschilberz@...> 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?
> Hi,

I use IB_Cursor both for reading and writing
for writing just do
select * from TAB or select TAB.* from TAB

no insert statement, IB_Datapump do it for you

Henry