1. Helge Opsvik
  2. PowerBuilder
  3. Sunday, 25 March 2018 18:11 PM

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?

Lars Mosegaard Accepted Answer Pending Moderation
  1. Tuesday, 27 March 2018 04:51 AM
  2. PowerBuilder
  3. # 1
0
Votes
Undo

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

Comment
Many thanks, much appreciated! It was very helpful, and the issue is now solved.

  1. Helge Opsvik
  2. Tuesday, 27 March 2018 17:19 PM
There are no comments made yet.
Michael Kramer Accepted Answer Pending Moderation
  1. Monday, 26 March 2018 00:02 AM
  2. PowerBuilder
  3. # 2
0
Votes
Undo

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 Accepted Answer Pending Moderation
  1. Sunday, 25 March 2018 18:41 PM
  2. PowerBuilder
  3. # 3
0
Votes
Undo

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.