Space between comma and field name in SELECT

5 Posts
2 Users
0 Reactions
188 Views
 Paul
(@paul)
Member
Joined: 2 months ago
Posts: 2
Topic starter  

Im new to this but I believe I have all my settings correctly configured to create the output I want.

Here is my input query:

SELECT field1 ,field2, field3 , * FROM table1

And my output looks like this

SELECT field1
    , field2
    , field3
    , *
FROM table1

Where I want to see this (without the space)

SELECT field1
    ,field2
    ,field3
    ,*
FROM table1

 
Here are the settings I currently have configured which seem relevant to this conversation:

  • General -> General Indentation = 4
  • General -> Alignment -> Align Comma = checked
  • General -> White Spaces -> White Spacces (typo) -> Around Commas = No Spaces
  • General -> White Spaces -> Remove unnecessary White Spaces = checked
  • SQL -> Alignment -> Indentaion = General Indentation
  • SQL -> Select -> I dont think my configuration issue has to do with these settings
  • SQL -> Select -> Lists -> Linebreaks -> Before Comma = checked
  • My version: SQLinFormDesktop: 6.25.5.18 - Parser 6.25.05.18

Also, when I execute this on the SQLinForm Desktop it works just the way I want it.  However, when I execute this on SSMS is when my spacing problem shows up.

Any thoughts?


This topic was modified 2 months ago by Paul

   
Quote
Guido
(@admin)
Member Admin
Joined: 4 years ago
Posts: 257
 

Hi Paul,

please try this

 

grafik

Regards

Guido


This post was modified 2 months ago by Guido

   
ReplyQuote
 Paul
(@paul)
Member
Joined: 2 months ago
Posts: 2
Topic starter  

Guido,

Thank you for the quick response!  I have my Lists -> Linebreaks set up just like you suggest.

Within the SQLinForm Desktop app, it works great.  However, in SSMS it's still showing up with the spaces.

Im on SSMS version 20.2.30.0

Do you have any additional thoughts on my issue?  Thanks!



   
ReplyQuote
Guido
(@admin)
Member Admin
Joined: 4 years ago
Posts: 257
 

Ok, thanks for the feedback. I need to publish a new version for SSMS20. Will do this tonight

Regards

Guido



   
ReplyQuote
Guido
(@admin)
Member Admin
Joined: 4 years ago
Posts: 257
 

Please download the new Release. Please read the installation instructions. They changed.



   
ReplyQuote
Share: