 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
sqltogo
Joined: 02 Jul 2014 Posts: 38 Country: Netherlands |
|
Beta test 7.0 Format Code |
|
If I enter this SQL
CREATE table [dbo].[MyTable] (
c1 INT NOT NULL,
c2 nchar(10) NULL,
c3 numeric(10,2)
);
INSERT mytable VALUES (1, '', 2 ), (3 , '' , 4), (5 , '' , 6);
And then format this code, I get this formatting
INSERT mytable
VALUES
(
1
, ''
, 2
), (3 , '' , 4), (5 , '' , 6);
I would expect the last lines also reformatted.
It is not a big issue, but it would be (to me at least) just a bit more consistent is all code is reformatted
|
|
Thu Jul 03, 2014 3:39 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
The pre-defined rules in SQL Assistant options do not support this kind of syntax.
Try changing the INSERT rule in SQL Assistant options and replacing
 |
 |
INSERT ...
(
...,
...
)
VALUES
(
...,
...
) |
 |
 |
INSERT ...
(
...,
...
)
VALUES
(
...,
...
),
(
...,
...
)
|
I haven't tried the above, just guessing it will do the trick
|
|
Thu Jul 03, 2014 8:15 pm |
|
 |
sqltogo
Joined: 02 Jul 2014 Posts: 38 Country: Netherlands |
|
|
|
I tried your suggestion and it works.
Nice solution, I saved the settings so I wil not loose this.
It also gave me the way to try when I encounter similar issues when formatting is not exactly what I like.
Thanks.
|
|
Fri Jul 04, 2014 3:21 pm |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|