comments confuse reformat

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

comments confuse reformat

Postby rbennet8 » Thu Oct 25, 2012 2:02 pm

consider this snippet.
@back_up_path varchar(500), -- path for backup directory
@log_path varchar(500), -- path for log directory
@JobID BINARY(16),
If you choose comma first, reformat changes it to
,@back_up_path VARCHAR(500)
, -- path for backup directory
@log_path VARCHAR(500)
, -- path for log directory
@JobID BINARY(16)
it should be reformatted as this
,@back_up_path varchar(500) -- path for backup directory
,@log_path varchar(500) -- path for log directory
,@JobID BINARY(16)
rbennet8
 
Posts: 49
Joined: Mon Feb 20, 2006 10:00 pm

Postby Manfred.Castro » Fri Oct 26, 2012 7:32 pm

Sorry you are experiencing this.
This is a known issue and there is an existing feature request to better handle comments in our uservoice forums you may want to vote for.
http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions/suggestions/1872709-moving-commas-from-end-to-start-is-always-bugg
These forums are monitored by our developers and allow our users to request features and vote on them.
If a request receives significant support the feature may be included in a future release.
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests