[Solved] Proper Handling of a comment in one row

3 Posts
2 Users
0 Reactions
587 Views
Posts: 2
Topic starter
(@ralphh)
Member
Joined: 2 years ago
[#120]

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!

 

 


2 Replies
Guido
Posts: 295
Admin
(@admin)
Member
Joined: 5 years ago

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

 


Reply
Posts: 2
Topic starter
(@ralphh)
Member
Joined: 2 years ago

Thanks for your prompt reply.

I sent eMail as advised.


Reply
Share: