Discussions tagged Query
When querying using query mode when connected to Oracle 19c, and the column being queried has an alias, the oracle statement looks like this.
(AND table.column aliase = 'Input data' )
Example:
In the select part:
COMPANY.STATUS COMPANY_STATUS
P...
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