  | 
			
				SoftTree Technologies 
				Technical Support Forums
			 | 
		 
		  | 
	 
	 
	
	
	
		
	
	
	
		| Author | 
		Message | 
	 
	
		
			mksql 
			 
			
  
			
			
				Joined: 29 Dec 2006 Posts: 19 Country: United States | 
			 
			  
		 | 
		
			
				  Formatting columns containing functions | 
				     | 
			 
			
				If I have a SELECT column list, with functions that take multiple parameters (ex. ISNULL), the formatter splits the function into two lines:
 
 
	  | 
	
 
	  | 
	
 
SELECT
 
    col1,
 
    ISNULL(col2,
 
    0)
 
FROM ...
 
 | 
	 
 
 
 
I have not figured out a pattern to prevent this. Suggestions?
  | 
			 
		  | 
	 
	
		| Wed Oct 03, 2007 4:48 pm | 
		           | 
	 
	
		  | 
	 
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				I'm unable to reproduce this. Which version are you running?
  | 
			 
		  | 
	 
	
		| Wed Oct 03, 2007 5:02 pm | 
		          | 
	 
	
		  | 
	 
	
		
			mksql 
			 
			
  
			
			
				Joined: 29 Dec 2006 Posts: 19 Country: United States | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				Version 2.5.20. My current format template:
 
 
	  | 
	
 
	  | 
	
 
SELECT ... AS ...,
 
       ... = ...,
 
       ... (..., ...)
 
FROM ... AS ...,
 
    ... JOIN ... ON ... = ...
 
      AND ...,
 
   (...)
 
WHERE  ... = ...
 
  AND  ...
 
   OR  (...)
 
GROUP BY
 
       ...,
 
       (...)
 
HAVING ...,
 
       (...)
 
ORDER BY
 
       ...,
 
       (...)
 
 | 
	 
 
  | 
			 
		  | 
	 
	
		| Wed Oct 03, 2007 6:12 pm | 
		           | 
	 
	
		  | 
	 
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				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?
 
 
	  | 
	
 
	  | 
	SELECT 1, isNull(2, 3) FROM dummy | 
	 
 
  | 
			 
		  | 
	 
	
		| Wed Oct 03, 2007 10:04 pm | 
		          | 
	 
	
		  | 
	 
	
		
			mksql 
			 
			
  
			
			
				Joined: 29 Dec 2006 Posts: 19 Country: United States | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				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 | 
		           | 
	 
	
		  | 
	 
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				Thanks for the update
  | 
			 
		  | 
	 
	
		| Thu Oct 04, 2007 3:14 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
  | 
   
 
		 | 
	 
	  |