 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
[SA 7.3.435 Pro] - In-line parentheses formatting issues |
|
I've got a formatting issue when the formatting affect code that has SELECT statements in parentheses. I've got the Text Length for In-line Parentheses setting set to 200. Still the following code
 |
 |
SELECT
k.kocsiall_id AS kocsiallas_id
,k.foldhely_id AS foldhely_id
,k.kocsiall_gps_x AS gps_x
,k.kocsiall_gps_y AS gps_y
,k.kocsiall_gps_z AS gps_z
,CAST(LTRIM(RTRIM(k.kocsiall_szam)) AS NVARCHAR(8)) AS kocsiall_szama
,51 AS volan_id
--,'' AS irany
,RTRIM(k.kocsiall_szam) + '. megálló' AS irany
,k.datum_tol AS datum_tol
,k.datum_ig AS datum_ig
FROM
ext.s_kocsiall AS k
WHERE 1 = 1
AND
(
k.datum_tol <= GETDATE()
AND (GETDATE() < k.datum_ig + 1 OR k.datum_ig IS NULL)
)
AND k.kocsiall_id != ALL (
SELECT
k.kocsiall_id
FROM
[DATA].mumus.kocsiall_hibak AS kh
)
|
refuses to be formatted as
 |
 |
SELECT
k.kocsiall_id AS kocsiallas_id
,k.foldhely_id AS foldhely_id
,k.kocsiall_gps_x AS gps_x
,k.kocsiall_gps_y AS gps_y
,k.kocsiall_gps_z AS gps_z
,CAST(LTRIM(RTRIM(k.kocsiall_szam)) AS NVARCHAR(8)) AS kocsiall_szama
,51 AS volan_id
--,'' AS irany
,RTRIM(k.kocsiall_szam) + '. megálló' AS irany
,k.datum_tol AS datum_tol
,k.datum_ig AS datum_ig
FROM
ext.s_kocsiall AS k
WHERE 1 = 1
AND (k.datum_tol <= GETDATE() AND (GETDATE() < k.datum_ig + 1 OR k.datum_ig IS NULL))
AND k.kocsiall_id != ALL (SELECT k.kocsiall_id FROM [DATA].mumus.kocsiall_hibak AS kh)
|
It ends up
 |
 |
SELECT
k.kocsiall_id AS kocsiallas_id
,k.foldhely_id AS foldhely_id
,k.kocsiall_gps_x AS gps_x
,k.kocsiall_gps_y AS gps_y
,k.kocsiall_gps_z AS gps_z
,CAST(LTRIM(RTRIM(k.kocsiall_szam)) AS NVARCHAR(8)) AS kocsiall_szama
,51 AS volan_id
--,'' AS irany
,RTRIM(k.kocsiall_szam) + '. megálló' AS irany
,k.datum_tol AS datum_tol
,k.datum_ig AS datum_ig
FROM
ext.s_kocsiall AS k
WHERE 1 = 1
AND (k.datum_tol <= GETDATE() AND (GETDATE() < k.datum_ig + 1 OR k.datum_ig IS NULL))
AND k.kocsiall_id != ALL (
SELECT
k.kocsiall_id
FROM
[DATA].mumus.kocsiall_hibak AS kh
)
|
instead.
Could there be something in my settings/formatting rules that could interfere with this? Or are those things that have a valid formatting rule going to be formatted regardless of the value set for Text Length for In-line Parentheses?
|
|
Wed Dec 02, 2015 12:09 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
|
|
|