QUICK: "Record has been changed since you found it. (FILE-B*03)"

roger32909 at bellsouth.net roger32909 at bellsouth.net
Thu Apr 6 14:16:33 CDT 2006


OpenVMS ALPHA V7.3-2, Q D E S I G N   (7.10.G1)
Copyright 1998 COGNOS INC. (ALPHA)
Licensed PH-AXP-DEVELOPMENT 

We have a screen with a DETAIL file FILE-A that OCCURS 6 TIMES.

Then there is a SECONDARY file FILE-B that OCCURS with FILE-A.
which is opened for UPDATE only, NODELETE and NOITEMS.

Some fields in this secondary file are updated when a new
FILE-A record is created or changed.  The data in these fields
must be removed in event a FILE-A record is deleted.
This works fine.

There are also two REFERENCE files FILE-C and FILE-D that OCCUR with FILE-B.

But a problem occurs when a FILE-A record is deleted.  Even after update,
the OCCURRENCE for this deleted record is apparently still there,
hence a mostly blank line in the cluster.  I say mostly blank,
because a field displayed from FILE-B remains even after the
related FILE-A record is deleted.
And then, if the user attempts to add a FILE-A record using the same
key from the deleted FILE-A record, an error message displays:
"Record has been changed since you found it. (FILE-B*03)"

How can we clear the buffers or break the "link" between this deleted DETAIL record in FILE-A
and the SECONDARY FILE-B record so the user can enter a FILE-A record
with the same key as the deleted DETAIL FILE-A record without getting
an error message?



More information about the powerh-l mailing list