1. Julian _
  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.