Stacked list - space after comma

[TcoleFT]

In the Stacked List options, there is an option of "No space between comma and list item in stack". It would be nice if this option was changed to allow for a single space between the comma and the list item. Thus, instead of:

Code: Select all

Select
	PP.ProductId
	,PP.MakeFlag
	,PP.FinishedGoodsFlag
	,Columns_Updated()
	,NullIf( PP.MakeFlag, PP.FinishedGoodsFlag ) As 'Null if Equal'

We would get:

Code: Select all

Select
	PP.ProductId
	, PP.MakeFlag
	, PP.FinishedGoodsFlag
	, Columns_Updated()
	, NullIf( PP.MakeFlag, PP.FinishedGoodsFlag ) As 'Null if Equal'

[alexa]

Please perform the following:

1. Select 'SQL Complete -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Formatting -> Profiles' branch.
3. Select the active profile.
4. Click 'Edit Profile...'. The 'Edit Profile' window opens.
5. Expand the 'SELECT -> Select List' node.
6. Unselect the 'Stack columns' option.
7. Navigate to the 'Spacing -> Delimiters' node.
8. Select the 'Insert space after comma' option.
9. Click 'OK'.

[TcoleFT]

If I disable Stacked Lists, then I get

Code: Select all

Select PP.ProductId, PP.MakeFlag, PP.FinishedGoodsFlag, Columns_Updated(), NullIf( PP.MakeFlag, PP.FinishedGoodsFlag ) As 'Null if Equal'

Instead of

Code: Select all

Select
   PP.ProductId
   , PP.MakeFlag
   , PP.FinishedGoodsFlag
   , Columns_Updated()
   , NullIf( PP.MakeFlag, PP.FinishedGoodsFlag ) As 'Null if Equal'

I would like to have Stacked Lists *and* a space after each comma.

[alexa]

Sorry for the confusion. Please try the following:
1. Select 'SQL Complete -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Formatting -> Profiles' branch.
3. Select the active profile.
4. Click 'Edit Profile...'. The 'Edit Profile' window opens.
5. Expand the 'SELECT -> Select List' node.
6. Select the 'Stack columns -> simple list' option.
7. Navigate to the 'Spacing -> Delimiters' node.
8. Select the 'Insert space after comma' option.
9. Navigate to the 'Stacked List' node.
10. Unselect the 'No space between comma and list item in stack' option.
11. Navigate to the 'Text Editor Options' section below the tree and select the 'Insert spaces' radio-button.
12. Click 'OK'.

[TcoleFT]

Awesome! Thank you. That did it.