MVP
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
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
