PowerBuilder

Examining the TransactionObject in PowerBuilder During Update and Delete

by
PowerBuilder logo

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 … Read more

Use “IS NULL” Rather Than “= NULL” When Upgrading to Newer Versions of SQL Server

by
Microsoft SQL Server logo

I’ve been upgrading an old Sybase PowerBuilder 6.5 app to a much newer version, SAP PowerBuilder 12.6. During this little adventure, I’ve had to update much of the hard-coded SQL code that was originally written for SQL Server 4.2, and was later upgraded to SQL Server 2000. This application’s database had been running on SQL Server … Read more