SQLinForm SQL Formatter

Tix2garr

(@tix2garr)

Member

Joined: 3 years ago

Posts: 5

Topic starter 19/04/2024 7:41 pm

I'm currently using 6.24.4.1 in Notepad++ and 6.24.03.30 (GUI)/6.24.03.22 (engine release) desktop version and they are both doing the same thing.

Prior to the last update or so, my DECLARE statement would look like:

DECLARE @SQL VARCHAR( MAX ) = ''
   , @SQL2 VARCHAR( MAX ) = ''
   , @Type VARCHAR( 6 ) = 'F0004'
   , @LinkToTable NVARCHAR( 150 ) = 'Something'
   , @LinkToColumn NVARCHAR( 150 ) = 'Something else'
   , @LinkValue NVARCHAR( 150 ) = ''
   , @Start VARCHAR( 2 ) = '6'
   , @NumChars VARCHAR( 2 ) = '6'

Line break before comma.

Now, however, it is doing this:

DECLARE @SQL VARCHAR ( MAX ) = ''                   ,
   @SQL2 VARCHAR ( MAX ) = ''                       ,
   @Type VARCHAR ( 6 ) = 'F0004'                    ,
   @LinkToTable NVARCHAR ( 150 ) = 'Something'      ,
   @LinkToColumn NVARCHAR ( 150 ) = 'Something else',
   @LinkValue NVARCHAR ( 150 ) = ''                 ,
   @Start VARCHAR ( 2 ) = '6'                       ,
   @NumChars VARCHAR ( 2 ) = '6'

I can't find any settings for DECLARE to "fix" it. Everywhere I can find, I have line break before the comma.

Help, please.

Michael

Quote

Guido

(@admin)

Member Admin

Joined: 3 years ago

Posts: 234

19/04/2024 9:33 pm

Dear @tix2garr,

thanks for your feedback. I will investigate

Regards

Guido

ReplyQuote

Guido

(@admin)

Member Admin

Joined: 3 years ago

Posts: 234

19/04/2024 11:00 pm

I found the reason for this issue.

Until now I used this option (see screenshot) to control linebreaks before/after comma for Commands like the EXEC.

Now this option is only impacting linebreaks for Parms as it is said in the Panel

I will need to add another option to control linebreak for statements

ReplyQuote

Tix2garr

(@tix2garr)

Member

Joined: 3 years ago

Posts: 5

Topic starter 22/04/2024 1:35 pm

I would very much appreciate that.

Interesting side note, though... no matter what I have checked, or not checked, in the Before Comma and After Comma checkboxes, it doesn't affect the commas in the declare statement. Wacky. <wry smile>

Michael

This post was modified 12 months ago by Tix2garr

ReplyQuote

Tix2garr

(@tix2garr)

Member

Joined: 3 years ago

Posts: 5

Topic starter 28/03/2025 3:13 pm

Any update on having a new parameter to handle linebreak for statements?

Michael

ReplyQuote

Guido

(@admin)

Member Admin

Joined: 3 years ago

Posts: 234

29/03/2025 1:42 pm

Thanks for the reminder. In SQL Sever I can see 3 different statements where the comma rule would apply

Do you see any other statment where the comma linebreak rule could be applied?

ReplyQuote

Tix2garr

(@tix2garr)

Member

Joined: 3 years ago

Posts: 5

Topic starter 31/03/2025 2:49 pm

For SQL Server...

Procedure/function Parameters - CREATE PROCEDURE name @var type, @var type... AS
EXEC sproc var, var, var
INSERT INTO table (field, field...) VALUES (value, value...)
SELECT field, field...
ORDER BY field, field, ...
GROUP BY field, field, ...
My Lists... (really like this, by the way!)
- Some of mine: IN, CONVERT, TRY_CONVERT, DECIMAL, IIF, ISNULL, LEFT, PATINDEX, RIGHT, SUBSTRING
UPDATE ... (field = , field = ...)
DECLARE @var type, @var type, ...
SET @var =, @var =, ...
- Which can also be SELECT @var =, @var =, ...
CREATE TABLE name ( file type, field type, ...)

Those are the "only" ones I could think of/find. Yes, most of the rest of them are already covered somewhere, but wanted to be as complete as I could.

There are much more specific ones like CREATE INDEX, etc., but those are a pain no matter what. (I just put --FORMAT_OFF / --FORMAT_ON around them. <chuckle>)

Back to you!

Michael

ReplyQuote

Guido

(@admin)

Member Admin

Joined: 3 years ago

Posts: 234

31/03/2025 9:56 pm

OK, thanks. First tests ran fine. I will try to improve the indentions which looks sometimes ugly, when there are only 2 vars

ReplyQuote

Tix2garr

(@tix2garr)

Member

Joined: 3 years ago

Posts: 5

Topic starter 01/04/2025 2:48 pm

Sounds like a plan. Thank ya much!!

Michael

ReplyQuote

Guido

(@admin)

Member Admin

Joined: 3 years ago

Posts: 234

14/04/2025 10:08 pm

Hi,

the new release is available for Download with a few new options

ReplyQuote

SQL Server - DECLARE and commas