SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[SA 7.3.435 Pro] - In-line parentheses formatting issues

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[SA 7.3.435 Pro] - In-line parentheses formatting issues
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 1395

Post [SA 7.3.435 Pro] - In-line parentheses formatting issues Reply with quote
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
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
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)

It ends up
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
        )

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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.