1. Julian I.
  2. PowerBuilder
  3. Thursday, 25 November 2021 11:52 AM UTC

Hi,

We were having a problem: When we tried to edit a datawindow through the "Data Source" option, the PB19 exploded.

We have detected that the problem occurs when in a "(CASE ... END)" sentence is included a comment with an unclosed parenthesis

Example:

SELECT (CASE WHEN (1 = 1) /* COMMENT WITH UNCLOSED PARENTESIS -> EXPLODE ( */ THEN 1 ELSE 0 END) AS TEST
FROM DUAL

¿Is it is a common PB19 versión issue? ¿Can someone to test it?

PB19 Version 2019 Build 2170

Conection "ORA Oracle"  Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

Regards,

Julian

 

 

René Ullrich Accepted Answer Pending Moderation
  1. Thursday, 25 November 2021 14:08 PM UTC
  2. PowerBuilder
  3. # 1

Hi Julian,

I can reproduce it with PB 2019 R3 Build 2703. It is also with only a closing parantesis in the comment.

You should open a support ticket.

Regards,

René

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 25 November 2021 14:13 PM UTC
Hi Rene ... I can remember this SQL "comment" issue from way back when Sybase 1st took over PB from PowerSoft. :-(
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.