R
romelwell
Guest
SETUP: PREFER-DATASET is set to FALSE (Default setting) MERGE-BY-FIELD is set to TRUE (Default setting) TEST: User Sally requests the Department record for Department ID 001. User Joe requests the Department record for Department ID 001. Sally updates the Department Category code from 'AAA' to 'BBB'. Sally commits her update, calling SAVE-ROW-CHANGES. Joe updates the Department Status from 'Active' to 'Inactive'. Joe attempts to commit his update, calling SAVE-ROW-CHANGES, however the DB sets ERROR-STATUS:ERROR because the before-image for Joe's record has been updated (Sally's change to the field Category Code) in the DB since Joe first requested the record. QUESTION: Using a combination of SAVE-ROW-CHANGES, PREFER-DATASET and possibly MERGE-BY-FIELD (or another property), is it possible to save Joe's updates and return to the caller an updated record that has both Joe's update and the earlier update from Sally to another field in the same record, without causing ERROR-STATUS:ERROR to be set?
Continue reading...
Continue reading...