• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Datawindow with outer join and left or right outer join - fails to retrieve data

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Datawindow with outer join and left or right outer join - fails to retrieve data

  1. Issue
0
Votes
Undo
  1. Helge Opsvik
    Helge Opsvik
  2. PowerBuilder
  3. Sunday, 25 March 2018 18:11 PM UTC

After migrating my application from Powerbuilder 9.0 to Powerbuilder 2017 (build 1681) I’ve got problems - the application fails to retrieve data if the datawindow has an outer join statement with left or right outer join. Errorcode -131 / SQLSTATE 37000. I have a Windows Server 2016 Standard 64 bit and Sybase SQL Anywhere 12 (12.0.1.3152). When I use the old application (Powerbuilder 9.0) everything is ok.
When I use the new appliction on my local PC (where I have Powerbuilder 2017 and Sybase SQL Anywhere 12 installed) everything is ok.

Anyone who has an suggestion?

  1. Build
  2. DataWindow
  3. JOIN
Profiling/Tracing :: Doc and.or Other (better) too...
PowerBuilder service application (Windows service)
Responses (3)
Lars Mosegaard
Lars Mosegaard Accepted Answer Pending Moderation
  1. Tuesday, 27 March 2018 04:51 AM UTC
  2. PowerBuilder
  3. # 1

There could be a change in the defaults of the DBPARM connection string: DelimitIdentifier='Yes'

Comment
Helge Opsvik
  1. Helge Opsvik
  2. Tuesday, 27 March 2018 17:19 PM UTC
Many thanks, much appreciated! It was very helpful, and the issue is now solved.

  1. Helpful
There are no comments made yet.
Michael Kramer
Michael Kramer Accepted Answer Pending Moderation
  1. Monday, 26 March 2018 00:02 AM UTC
  2. PowerBuilder
  3. # 2

Hi Helge,

Out of curiosity: I wonder how the SQL syntax in the DataWindow/DataStore SQLPreview event compares PB 9 vs. PB 2017.

If syntax is different and you have a chance to correct it on-the-fly, then you have a workaround until a product fix is in place.

In any case, you should go ahead and report the issue as Armeen requests.

HTH /Michael

Comment
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Sunday, 25 March 2018 18:41 PM UTC
  2. PowerBuilder
  3. # 3

Since this worked fine in PB 9, please open a support ticket and provide your repro test case.  https://www.appeon.com/standardsupport/

Comment
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.