1. Michael Kramer
  2. PowerBuilder
  3. Friday, 30 August 2019 13:21 PM UTC

IDE Setup

  • PowerBuilder 2017 R3 Standard Edition, build 1858.
  • Connected to MSSQL 2012 (SP4) using ADO.NET.
  • System Options as follows:
    • [ ON ]  Free Database Driver Libraries on Disconnect
    • [ OFF ]  Disable database connection when compiling and building

 

Experienced Behavior

Database Painter SELECT Odd
FROM Someone.Knows;
Error: Invalid object name 'Someone.Knows'
UserObject Painter int Behavior
SELECT Odd INTO :Behavior
FROM Someone.Knows;
Silence when compile or save

Why don't I see warnings when embedded SQL is invalid?

I tell myself IDE used to complain of my table/column name typos. Am I wrong?

/Michael

Roland Smith Accepted Answer Pending Moderation
  1. Friday, 30 August 2019 14:38 PM UTC
  2. PowerBuilder
  3. # 1

PB 12.5.2 with ODBC connection to SQL Server 2016

I get the error message.

 

Try ODBC, SNC, or OLEDB connections to see how they handle it.

 

Comment
  1. Michael Kramer
  2. Friday, 30 August 2019 15:02 PM UTC
THX, Roland. I'm testing several combos. Issue repeats no matter what I do.



I verified that

1) "Disable DB connection" is OFF

2) Script painter's "Display DB warnings" is ON

3) PB IDE's DB connection is alive



TEST A: Original PC but via SNC (SQLNCLI11) => No warnings

TEST B: Other PC, PB 2017R3, #1858 via SNC to MSSQL 2016/SP1 (localDB) => No warnings

TEST C: "Other PC", PB 2019, #2082 via ODBC to SQLAny V16 => No warnings



Syntax error are caught like INTO :UNKNOWN-var -- but DB errors are NOT caught.

My gut feeling is some config option disables the DB dictionary lookups. Just no clue why.
  1. Helpful
  1. Miguel Alzate
  2. Saturday, 11 November 2023 15:58 PM UTC
Hi, Michael. Could you finally resolve this issue? If so, how?
  1. Helpful
  1. Miguel Alzate
  2. Saturday, 11 November 2023 17:01 PM UTC
It also happens in PB 2022 R2!
  1. Helpful
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.