I am trying to debug a database error my application throws randomly.
I have a window with two shared DataWindows on it. Most of the time when I modify and save everything works fine. But on some records the application throws a "row changed between retrieve and update" error.
I read here that it could be to do with the database/triggers. I have been through debugging but cannot seem to find the actual query that gets executed.
I don't think this is an error with the application itself as I have been able to modify the same column of other records using the same process. so I think there has to be something wrong with the query for this particular record.
The closest I could find to the query being executed was:
string sqlsyntax = "UPDATE "TABLENAME" SET "CHANGED_ROW" = :1 WHERE "TABLE_ROW_1" = :2 AND "TABLE_ROW_2" = :3 AND .. etc".
But cannot see what the values of :1, :2 etc are to get a full idea of what the query is, and hopefully why it is happening for this particular record.
Is there a way to view the exact query that is being executed against the database?
It is an Oracle database, application is PB 12.5 classic