N_A!
  • Posts: 12
  • Joined: 12/2/2015
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!
  • Posts: 12
  • Joined: 12/2/2015
Originally Posted by: N_A!

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
N_A!
  • Posts: 12
  • Joined: 12/2/2015
v3.9, still there... In general, it seems that everything that starts from the beginning of the line (i.e. in FROM and JOINS too) contains a tab and after that, the <space> in settings is followed.
----------
Nick
  • 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.