DataWindow Error: Row changed between retrieve and update

Question

I am getting an error when updating a DataWindow which says "Row changed between retrieve and update". What is the solution?

Answer 1

This can occur if you are displaying the same row(s) in more than one (non-shared) DataWindow and then try to update them both. Other causes are incorrect use of SetItemStatus(); incorrect use of the status flags on the update() statement; and finally, the cause this is intended to detect, another user updated the row before you.