Discussions tagged Query
Adding alias to column gives ORA- 00920 when using query mode with Oracle
- Issue
- Last updated 6 months ago
- Chris Pollach @Appeon replied 6 months ago
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...
How to cancel a long running query in PowerServer CloudApp
- Resolved
- How-to
- Last updated 1 year ago
- Logan Liu @Appeon replied 1 year ago
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 with SQL Server db query slow
- Resolved
- Advice
- Last updated 1 year ago
- Miguel Leeuwe replied 1 year ago
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...
Powerbuilder and SQL Server Multiple Plans
- Advice
- Last updated 1 year ago
- Markus Eckert replied 1 year 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
- How-to
- Last updated 3 years ago
- mike S replied 3 years 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
- Issue
- Last updated 3 years ago
- Chris Pollach @Appeon replied 3 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 ]
- How-to
- Last updated 4 years ago
- Michael Kramer replied 4 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?
- Issue
- Last updated 5 years ago
- Sivaprakash BKR replied 5 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 :
- 1