Hi all, we were checking our databases using the various sp_Blitz procedures (First Responder Kit) and we discovered something we had hints before: SELECT statements produced by our PowerBuilder (2017 using SNC) application's datawindows create lot...

Any search window in our system gets a search criteria with the DW query mode. But when a DW is in query mode I cannot specify any string value starting with 'IN-' in any field on the DW. Can anyone point out what is going on and how to solve the is...

Hello, since I migrated an old app developped with PB 7 to PB 2019, I have a big problem with some SQL queries from my Datawindows when executed on a database under Oracle 11g. I get this message : 1722 - select Error : SQLstate = 22005.  But the s...

I am working on some of features available in Appeon (PowerBuilder 2019) for upgrading from the old version. I need some information/help for the following topics Converting Blob into string I am encrypting the plain text using “SymmetricEncryp...

A PowerBuilder datawindow has some parameters and those parameters are obviously matched with columns in query of the datawindow. The query is too complex. In my script i get the query syntax in a string variable. Also i get parameters list defined i...