Page 1 of 1
Stacked list - space after comma
Posted: Sun 14 Aug 2016 20:54
by 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'
Re: Stacked list - space after comma
Posted: Mon 15 Aug 2016 09:17
by 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'.
Re: Stacked list - space after comma
Posted: Mon 15 Aug 2016 15:58
by 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.
Re: Stacked list - space after comma
Posted: Tue 16 Aug 2016 08:57
by 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'.
Re: Stacked list - space after comma
Posted: Tue 16 Aug 2016 23:40
by TcoleFT
Awesome! Thank you. That did it.