Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Adding alias to column gives ORA- 00920 when using query mode with Oracle

  1. Issue
0
Votes
Undo
  1. Erling Kjerland
    Erling Kjerland
  2. PowerBuilder
  3. Tuesday, 2 April 2024 15:19 PM UTC

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

PowerBuilder then constructs this addition to the where conditions.

(AND COMPANY.STATUS COMPANY_STATUS = 'A')

This results in Oracle error "ORA-00920 Invalid relational operator".

The alias should not have been included in the select when Oracle native connection is used.

 

We are using PowerBuilder 2021, build 1506. 

 

Erling Kjerland

  1. DataWindow
  2. Oracle
  3. PowerBuilder (Appeon)
  4. Query
  5. SQL
Null Reference in newer versions of PB
Incorrect EOL notification
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 2 April 2024 16:53 PM UTC
  2. PowerBuilder
  3. # 1

Hi Erling ;

  Note that PB 2021 is past it's End-of-Maintenance period as of 2023.09.04 so if the issue still exists in a supported Appeon PB release Appeon would certainly delve into the problem & provide a fix. First of all though, I would suggest downloading PB 2022 R3 (it can co-exist with PB 2021) and try to see if you can recreate the same problem in that latest release. If you can create a simple PB App reproducible test case in PB 2022 R3, please open a support ticket for this issue. Since PB 2021 is past it's End-of-Maintenance the fix will probably only be available in the 2022 R3 release and thus you would need an upgrade to have this resolved.  Many thanks in advance!

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.