-
Miguel Alzate
- PowerBuilder
- Sunday, 26 July 2026 04:24 PM UTC
Hi, everyone!
During some tests I noticed an unexpected behavior.
Environment:
PB 2019 R2 Build 2323
PB 2022 R3
SQL Server
Embedded SQL in an NVO
Display Database Warnings enabled
When compiling:
SELECT nonexistent_column
INTO :ls_value
FROM employee;
PowerBuilder correctly reports a database warning (invalid column)
However:
SELECT employee_name
INTO :ls_value
FROM nonexistent_table;
does not produce any warning when using SNC or MSOLEDBSQL (invalid table)
Interestingly, when I change only the Database Profile to ODBC, PowerBuilder immediately reports that the table does not exist.
Has anyone observed the same behavior?
Is this expected?
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.