SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Formatting columns containing functions

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Formatting columns containing functions
Author Message
mksql



Joined: 29 Dec 2006
Posts: 19
Country: United States

Post Formatting columns containing functions Reply with quote
If I have a SELECT column list, with functions that take multiple parameters (ex. ISNULL), the formatter splits the function into two lines:

Code:

SELECT
    col1,
    ISNULL(col2,
    0)
FROM ...


I have not figured out a pattern to prevent this. Suggestions?
Wed Oct 03, 2007 4:48 pm View user's profile Send private message Yahoo Messenger
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6513

Post Reply with quote
I'm unable to reproduce this. Which version are you running?
Wed Oct 03, 2007 5:02 pm View user's profile Send private message
mksql



Joined: 29 Dec 2006
Posts: 19
Country: United States

Post Reply with quote
Version 2.5.20. My current format template:

Code:

SELECT ... AS ...,
       ... = ...,
       ... (..., ...)
FROM ... AS ...,
    ... JOIN ... ON ... = ...
      AND ...,
   (...)
WHERE  ... = ...
  AND  ...
   OR  (...)
GROUP BY
       ...,
       (...)
HAVING ...,
       (...)
ORDER BY
       ...,
       (...)

Wed Oct 03, 2007 6:12 pm View user's profile Send private message Yahoo Messenger
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6513

Post Reply with quote
I tried that with your formatting pattern and 2.5.20 and I still cannot reproduce this issue.

Could it be something in column or table names? Does it happen for a simplequery like below?

Code:
SELECT 1, isNull(2, 3) FROM dummy

Wed Oct 03, 2007 10:04 pm View user's profile Send private message
mksql



Joined: 29 Dec 2006
Posts: 19
Country: United States

Post Reply with quote
I am now unable to reproduce the issue either, with your sample or my code. Perhaps it was something very specific. If it appears again, I will post a more detailed example.
Thu Oct 04, 2007 10:30 am View user's profile Send private message Yahoo Messenger
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6513

Post Reply with quote
Thanks for the update
Thu Oct 04, 2007 3:14 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.