• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • DW Edition Crash comment unclosed parenthesis on CASE

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

Resolved DW Edition Crash comment unclosed parenthesis on CASE

  1. How-to
0
Votes
Undo
  1. Julian I.
    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

 

 

請教 PowerBuilder 各版本功能差別
Insert a string(plain text) into rich text control
Responses (1)
René Ullrich
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
Chris Pollach @Appeon
  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.