I am still getting "row changed between retrieve and update" any time I try to update a table where a datetime is in the list of updateable columns.
I tried setting datetimeformat in the ODBC database profile syntax tab but it still fails. Somehow the where clause value for a datetime is not matching the database value. I saw a previous post where an ORACLE fix was to use: ls_dateformat = "ALTER SESSION SET NLS_DATE_FORMAT = ~'dd/mm/yyyy HH24:MI:SS~'". I am using SQL server as indicated on screenshot below. Any ideas?
I recently migrated our PB client/server SQL Server application from PB10 to PB2021 successfully. I setup ODB ODBC database profiles and I am able to run. However in dw painter when I select data source I get the error below although table and columns look good in db painter. Also when I change update properties on a datawindow, I also get "table not found" and I receive "row changed between retrieve and update" in app and dw painter when my dw update properties are "key and updateable columns" or "key and modified columns" (on any update). It worked using "Key columns". I have no db triggers or any other users in the app. These datawindows worked fine in PB10/SQL server 2014. Any ideas would be appreciated.
PB version:
DB painter:
