Discussions tagged Query

Hi, we have in our PB application, when running in C/S mode, the possibility to cancel a query returning large number of rows by issuing DBCancel(). In C/S mode it works fine. But in PS mode, it doesn't appear to do anything. Is there a way to can...
PowerBuilder version: 2019 R3 Build 2779 SQL Server 2019 ODBC Driver 17 for Sql Server I have a query that returns 109 rows in 2 seconds in Management Studio but takes upwards of 30 seconds in db painted within Powerbuilder.  Are there any setting...
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...
  • Page :
  • 1