- Roland Smith
- PowerBuilder
- Thursday, 9 August 2018 05:31 PM UTC
My app is written in PB 10.5 and can run against various databases of the user's choice. This includes ASE, SQL Anywhere, Oracle, SQL Server, and MySQL.
The helps says that SQLCode & SQLDBCode will not indicate errors. Presumably SQLErrText won't have a message either. It goes on that the only way to tell if an error occurred is to check SQLNRows. It also says that for Sybase ASE, you must use AutoCommit=True.
My question is: Are these statements in the help really true? What is the real best practice for working with database blobs?
I'm not having any problems with blobs that I am aware of. I'm adding a new function to the app and want to make sure it is coded correctly.
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.