Normally this problem comes in multiuser scenarios where some other user
has modified the record on which you are working. In a single user
scenario this will come only if the datawindow flags have not been
properly set/reset after an update command.
The best way to avoid the "row changed between retrieve and update"
error is to use the "Key columns" update option. If you have timestamps
or fields updated by triggers including them in the update statement
("Key and updateable columns") can cause problems.
No comments:
Post a Comment