1. Michael Kramer
  2. PowerBuilder
  3. Friday, 30 August 2019

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
0
Votes
Undo

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
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. Michael Kramer
  2. Friday, 30 August 2019
There are no comments made yet.
  1. Friday, 30 August 2019
  2. PowerBuilder
  3. # 1
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.