Subject RE: [IBO] RE: Datapump action
Author Riho-Rene Ellermaa
<At 10:21 AM 6/10/2003 +0300, you wrote:
>>Also, where is it possible to modify the Destination dataset's value for
>>some records?
>>At first I thought that AfterFetchRow can be used, but all my changes are
>>overwritten with original values.

>Why use a dataset for the DstStatement? Use a parameterised TIB_DSQL and
>put any data-massaging code into its BeforeExecute event.


I must pump 30 tables and to make things easier I use TIB_Cursors.
I have stringlist with tables names and while looping, I create
"SELECT * FROM " + Tablename[i]
for source and destination cursors.
It works fine, except this modifying problem.
I tried to use BeforePost on destination cursor, but I can't see any values from there and my modifications are overwritten.

IMO the AfterFetchRow should allow user to make necessary changes. Currently I can change only new fields that didn't exist in older database.

I dont kow if this is a bug or not, but if in destination database I have field that can't be NULL, but in source database it is NULL, then I get error (Field cannot be NULL) even if I supply the value in AfterFetchRow.

Riho-Rene Ellermaa
senior programmer