- Erling Kjerland
- PowerBuilder
- Tuesday, 2 April 2024 03: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
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.