During the upgrade of an application from Sybase PowerBuilder 6.5 to SAP PowerBuilder 12.6, I ran into a bug in the Update event that had me suspicious that the TransactionObject was somehow changing, causing the update to be directed toward a different database.
As it turns out, the bug was due to a trigger in the main database that was selecting data from another database.
Even so, I learned about something quite valuable: the SQLPreview event.
event sqlpreview this.setsqlpreview(sqlsyntax) end event
If you set a watch on sqlsyntax, you can see the SQL code associated with the data update.