logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
N_A!  
#1 Posted : Friday, September 8, 2017 1:41:46 PM(UTC)
Rank: Newbie
A minor bug in formatting.

I have created a custom format for SQL statements. My settings in Settings\Formatting are <spaces> for everything.

This works fine everywhere except for one place. In the following SQL statement:

SELECT *
FROM sys.tables
WHERE object_id = 162099618
AND type_desc = 'USER_TABLE'


before the "AND" in the "WHERE" part, SSMSBoost adds a tab instead of spaces.

Tried with the latest version - 3.1.6458
----------
Nick
N_A!  
#2 Posted : Monday, September 30, 2019 11:08:32 AM(UTC)
Rank: Newbie
Originally Posted by: N_A! Go to Quoted Post
A minor bug in formatting.


This bug still exists (v3.7.7170.22760). In Settings/Formatting/Where: Indent=False, IndentConditions=True, SpaceBefore=LineBreak, SpaceBeforeConditions=Space.

Still in this statement:

SELECT *
FROM Table1
WHERE (Field1=1)
AND (Field2=2)

the formatter adds a TAB before the "AND", instead of adding spaces.
----------
Nick
Rss Feed  Atom Feed
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.