Error when updating through prodataset

[Chamini]

Hi ,
For some records Im getting the following error when trying to save to the database through prodataset. This happens only for very few records.

"Unable to find record for db buffer <table> during SAVE-ROW-CHANGES (11912). "

KB says to upgrade to 10.0b in fact Im using 10.1B.

Can somebody please help me with this

Attached the piece of code for update.
FOR EACH ttAmmBefore TRANSACTION:
BUFFER ttAmmBefore:SAVE-ROW-CHANGES() NO-ERROR.
IF BUFFER ttAmmBefore:ERROR AND ERROR-STATUS:NUM-MESSAGES > 0 THEN
DO i = 1 TO ERROR-STATUS:NUM-MESSAGES:
cErrorMsg = cErrorMsg + chr(1) + ERROR-STATUS:GET-MESSAGE(i).
END.
IF Return-value > "" THEN
cErrorMsg = (IF cErrorMsg > "" THEN cErrorMsg + chr(1) + RETURN-VALUE ELSE RETURN-VALUE ) .
END.
Thanks
Chamini

 

[Ruchi Saxena]

I also had this error in the past. Check if all the UNIQUE index key fields have correct data in it for the record you are posting.

If the record getting posted does not have the corrrect data in index fields, Progress cant find the record in the DB and so cannot post the changes.

HTH,