Subject | RE: [IBO] Using DataPump |
---|---|
Author | Riho-Rene Ellermaa |
Post date | 2003-06-03T14:03:55Z |
Spoke too soon :)
Pump works OK when source and destination tables have identical names (at least it seems this way)
When I have
"select * from DOM_PAY" as source cursor
and
"select * from DOM_PAY_LV" as destination cursor
I get error "ID is required field"
If I set the value in AfterFetchRow event
dest->ByName("ID"->AsInteger= ARow->ByName("ID")->AsInteger;
then it finds next missing field.
Looks like Pump cannot match the source and destination datasets.
If I open the Pump Editor and press ItemActions->Prepare, then Pump shows correct pairs in DstLinks, so it understands how to match them.
All hints are welcome.
Riho-Rene Ellermaa
senior programmer
-----Original Message-----
From: Riho-Rene Ellermaa [mailto:r.ellermaa@...]
Sent: Tuesday, June 03, 2003 3:14 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Using DataPump
Thanks, got it to work now
Riho-Rene Ellermaa
senior prog
[Non-text portions of this message have been removed]
Pump works OK when source and destination tables have identical names (at least it seems this way)
When I have
"select * from DOM_PAY" as source cursor
and
"select * from DOM_PAY_LV" as destination cursor
I get error "ID is required field"
If I set the value in AfterFetchRow event
dest->ByName("ID"->AsInteger= ARow->ByName("ID")->AsInteger;
then it finds next missing field.
Looks like Pump cannot match the source and destination datasets.
If I open the Pump Editor and press ItemActions->Prepare, then Pump shows correct pairs in DstLinks, so it understands how to match them.
All hints are welcome.
Riho-Rene Ellermaa
senior programmer
-----Original Message-----
From: Riho-Rene Ellermaa [mailto:r.ellermaa@...]
Sent: Tuesday, June 03, 2003 3:14 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Using DataPump
Thanks, got it to work now
Riho-Rene Ellermaa
senior prog
[Non-text portions of this message have been removed]