Discussions tagged Query
Powerbuilder and SQL Server Multiple Plans
- Last updated 5 months ago
- Markus Eckert replied 4 months ago
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...
DW Query mode does not like value 'In-' value in any field
- Last updated 1 year ago
- mike S replied 1 year ago
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...
Datawindow Retrieve Error : 1722 - select Error : SQLstate = 22005
- Last updated 2 years ago
- Chris Pollach @Appeon replied 2 years ago
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...
Information Required [ Appeon PowerBuilder 2019 Datatype Blob ]
- Last updated 3 years ago
- Michael Kramer replied 3 years ago
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...
How to get list of columns from a query?
- Last updated 4 years ago
- Sivaprakash BKR replied 4 years ago
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...
- Page :