Examining the TransactionObject in PowerBuilder During Update and Delete

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.

Leave a Reply