• 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)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Sunday, 25 March 2018 18:41 PM UTC
  2. PowerBuilder
  3. # 1

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.
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.
Lars Mosegaard
Lars Mosegaard Accepted Answer Pending Moderation
  1. Tuesday, 27 March 2018 04:51 AM UTC
  2. PowerBuilder
  3. # 3

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.
  • Page :
  • 1


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