  | 
			
				SoftTree Technologies 
				Technical Support Forums
			 | 
		 
		  | 
	 
	 
	
	
	
		
	
	
	
		| Author | 
		Message | 
	 
	
		
			birgerii 
			 
			
  
			
			
				Joined: 21 Feb 2007 Posts: 29
  | 
			 
			  
		 | 
		
			
				  Odd autocompletion in 3.0.21 | 
				     | 
			 
			
				Hello,
 
I experience the following.
 
step 1: I type "SELECT *
 
FROM oh
 
	INNER JOIN orp
 
		ON oh.OrderNr = orp.ordernr"
 
 
Then I start adding the columns I want to take a closer look at (bold text entered);
 
"SELECT orp.Ord
 
           , *
 
FROM oh
 
	INNER JOIN orp
 
		ON oh.OrderNr = orp.ordernr"
 
 
Then, when the Intellisense displays the list, I hit Enter and the result is:
 
"SELECT o.OrdAntal FROM orp o
 
           , *
 
FROM oh
 
	INNER JOIN orp
 
		ON oh.OrderNr = orp.ordernr"
 
 
I don't think it is supposed to work this way, or at least, it's not what I want. Is it a bug or can I correct this with a setting?
 
Best regards
 
Magnus
  | 
			 
		  | 
	 
	
		| Fri Nov 30, 2007 6:03 am | 
		          | 
	 
	
		  | 
	 
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				This is the designed behavior. It allows you to selected columns and move to the next line without closing the popup. If you want to expand *, click next to the asterisk and press Ctrl+Enter or wait for the balloon tip and click on the hyperlink in the tip. Select as many columns as required (use mouse or Arrow Right key to tick columns in the list) and press Esc to dismiss the popup.
  | 
			 
		  | 
	 
	
		| Fri Nov 30, 2007 11:21 am | 
		          | 
	 
	
		  | 
	 
	
		
			birgerii 
			 
			
  
			
			
				Joined: 21 Feb 2007 Posts: 29
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				Of course. 
 
I usually  use aliases and didnīt  see the reason for the behavior until now.
  | 
			 
		  | 
	 
	
		| Fri Nov 30, 2007 11:47 am | 
		          | 
	 
	
		  | 
	 
	
		 | 
	 
 
  
	 
	    
	   | 
	
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
  | 
   
 
		 | 
	 
	  |