Skip to Content
0
Former Member
May 30, 2014 at 03:41 AM

View full Query String when Debugging

270 Views

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

Thanks