[Solved] Prevent two hyphens in a string from being treated as a comment

4 Posts
2 Users
0 Likes
165 Views
(@benjamin-moeller)
Member
Joined: 2 years ago
Posts: 17
Topic starter  

Hello
I have the following SQL

SELECT
CASE
WHEN bs = 'B
THEN '12Xkljsdg--X'
ELSE receiverid
END AS buyerparty
from base.

However, if I have selected the setting that "Convert Line comments into Block Comments", it destroys the SQL for me.
The result is then:

SELECT
CASE
WHEN bs = 'B
THEN '12Xkljsdg/*--X'*/
ELSE receiverid
END AS buyerparty
from base

which is wrong.

How can I prevent this?

Greetings
Ben


   
Quote
Guido
(@admin)
Member Admin
Joined: 2 years ago
Posts: 175
 

Hi @benjamin-moeller,

thanks for your feedback.

This is a parser error.

Will fix this asap

Regards

Guido

 

 


   
ReplyQuote
Guido
(@admin)
Member Admin
Joined: 2 years ago
Posts: 175
 

Hi @benjamin-moeller,

please give the new Release 6.23.9 a try. This issue should be fixed

Regards

Guido


   
ReplyQuote
(@benjamin-moeller)
Member
Joined: 2 years ago
Posts: 17
Topic starter  

@admin Great!
This fast support alone is worth every cent of the licence!


   
ReplyQuote
Share: