Subject RE: [IBO] Using DataPump
Author Riho-Rene Ellermaa
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]