R
romelwell
Guest
Are there any opinions on the best method (most efficient) to write a record to a UserNote DB table using the before-image and after-image attributes of a buffer object handle? For example, a user updates an employee record by changing the department number associated to this employee. SETUP: The before-image of the buffer object would be: field: dept_no value: 7 The after-image of the buffer object would be: field: dept_no value: 8 When SAVE-ROW-CHANGES is called by the buffer object handle, the DB record is successfully updated in the data source. After SAVE-ROW-CHANGES, both the before-image and the after-image now have the same values (as expected): before-image: field: dept_no value: 8 after-image: field: dept_no value: 8 QUESTION: What are some design options available to our team to write a value to a UserNote table that would reflect the changes to the data successfully updated via SAVE-ROW-CHANGES? Assume we would like to write a note such as: "Department updated from 7 to 8 for Employee AB123". Thanks.
Continue reading...
Continue reading...