Subject | Datapump Question: What do i wrong? |
---|---|
Author | saschaschilberz |
Post date | 2008-11-27T09:05:57Z |
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?
greetings
Sascha
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?
greetings
Sascha