We are updating a MS SQL Server Database using a datawindow with Modified Columns used as the Update Criteria. We are always getting a failure "Row changed between retrieve and Update" (PB 2017 R3)
A datetime column in the database seems to be the cause of the problem. We automatically get a mismatch between the value retrieved and used in the modified value in the where clause. This looks to be a thousands of a second value which is not being stored by the datawindow which causes the Update using that value to fail.
We need to test to see if another task has similarly modified this row, so use of the modified is required.
Is this a known problem and is there a getaround?