[Solved] Proper Handling of a comment in one row

3 Posts
2 Users
0 Reactions
89 Views
(@ralphh)
Member
Joined: 4 months ago
Posts: 2
Topic starter  

Checking the notepad++ Plugin for a sql on db2 on z/os.

SQL eads like

select

field1 as alpha,

— field2 as beta,

field3 as gamma

from table1

;

works perfectly ignoring the entire string in the row identified as a comment by the — prefix.

when I use SqlinForm plugin with my current options it does not properly treat the comment row and creates

 

……

— field2

as

beta,

field3

as gamma

 

which obviously is syntactically wrong.

Seems it does not understand that a comment tow must be left untouched.

 

Are there any options to prevent this from happening.

 

Thanks for your help!

 

 


   
Quote
Guido
(@admin)
Member Admin
Joined: 3 years ago
Posts: 216
 

Hi @ralphh, thanks for your post.

I was not able to reproduce this issue.

grafik

In this small code snippet the formatter handles the line comment correctly

Could you please send me your code snippet and your exported formatting options to my email info @ sqlinform . com

Many thanks

Guido

 


   
ReplyQuote
(@ralphh)
Member
Joined: 4 months ago
Posts: 2
Topic starter  

Thanks for your prompt reply.

I sent eMail as advised.


   
ReplyQuote
Share: