We are currently trying to migrate our PB8 application to PB11 using the SQLServer native driver "SNC SQL Native Client(OLE DB)". The database backend is SQLServer 2000.
We are experiencing quite a few problems with trying to delete data. On most of our 250+ tables all is fine. But we have a few tables that when we delete a row we get the error 'Row changed between retrieve and update."
At first we thought that it was an issue with our application. But we have found out that deleting a row through the DataWindow painter we get the same error. We have also discovered we get the same error when deleting a row through the Database painter.
If we use an ODBC connection then everything works.
We have also discovered that if we drop and recreate the table where we previously received the error message we no longer get the error.
Dropping and recreating tables is our last resort. In fact if we can't find a better solution to this we will not migrate to PB11.
Has anyone else experienced this and if so did you find a different solution than dropping and recreating the problem tables?
We are experiencing quite a few problems with trying to delete data. On most of our 250+ tables all is fine. But we have a few tables that when we delete a row we get the error 'Row changed between retrieve and update."
At first we thought that it was an issue with our application. But we have found out that deleting a row through the DataWindow painter we get the same error. We have also discovered we get the same error when deleting a row through the Database painter.
If we use an ODBC connection then everything works.
We have also discovered that if we drop and recreate the table where we previously received the error message we no longer get the error.
Dropping and recreating tables is our last resort. In fact if we can't find a better solution to this we will not migrate to PB11.
Has anyone else experienced this and if so did you find a different solution than dropping and recreating the problem tables?