  | 
			
				SoftTree Technologies 
				Technical Support Forums
			 | 
		 
		  | 
	 
	 
	
	
	
		
	
	
	
		| Author | 
		Message | 
	 
	
		
			gemisigo 
			 
			
  
			
			
				Joined: 11 Mar 2010 Posts: 2175
  | 
			 
			  
		 | 
		
			
				  [11.3.279 Pro] - Questions: formatting of the inserted code | 
				     | 
			 
			
				In this video here you can see me typing INNER JOIN and then selecting a table from the list of possible candidates in the popup. 
 
 
My questions are:
 
 
#1 What determines the formatting of the inserted code fragment? 
 
#2 Why is it inserted broken into two lines?
  | 
			 
		  | 
	 
	
		| Wed Dec 16, 2020 8:23 am | 
		          | 
	 
	
		  | 
	 
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7991
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				I think it's hardwired into Intellisense, it's like
 
 
	  | 
	
 
	  | 
	... JOIN table clause
 
        ON column condition 1...  [AND column condition 2... depending on number of columns in the foreign key]
 
 | 
	 
 
 
 
The result can be reformatted using formatting rules.
 
 
This behavior of JOINs is a bit changing in the upcoming maintenance release, there are going to be more options for which parts of join to insert, with or without columns, one at a time, or all together, etc...
  | 
			 
		  | 
	 
	
		| Mon Dec 21, 2020 6:01 pm | 
		          | 
	 
	
		  | 
	 
	
		
			gemisigo 
			 
			
  
			
			
				Joined: 11 Mar 2010 Posts: 2175
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				That sounds great! Will there be an option not to break the code into multiple lines? Have you got an ETA for that release? (disregard that last question, I've seen the ETA in another topic, thanks for the info).
  | 
			 
		  | 
	 
	
		| Mon Dec 21, 2020 6:20 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
  | 
   
 
		 | 
	 
	  |