SQL Complete adds extra line after comment

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
ori_g
Posts: 11
Joined: Thu 22 Jun 2017 17:26

SQL Complete adds extra line after comment

Post by ori_g » Fri 13 Apr 2018 14:16

I have a stored procedure with a body somewhat like this:

Code: Select all

CREATE PROCEDURE MyProc
(
	@Var1 INT
)

AS

	-- Comment:
	IF @Var1 IS NULL
		...
Once I format it using SQL Complete, it adds an extra line after the comment to become:

Code: Select all

CREATE PROCEDURE MyProc
(
	@Var1 INT
)

AS

	-- Comment:
	
	IF @Var1 IS NULL
		...
What option can I change to stop that from happening?

Thanks.

alexa
Devart Team
Posts: 2442
Joined: Fri 24 Jun 2011 14:17

Re: SQL Complete adds extra line after comment

Post by alexa » Mon 16 Apr 2018 13:32

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 and click the 'Edit Profile...' button. The 'Edit Profile...' window opens.
4. Navigate to the 'Code -> IF' section.
5. Unselect the 'Add empty lines around IF statement' option.

Post Reply