| 
	
		| 
		
			|  | SoftTree Technologies Technical Support Forums
 |  |  
	
		| 
	
	
	
		| Author | Message |  
		| judahr 
 
 
 
 
			
				| Joined: 09 Mar 2007 Posts: 320
 Country: United States
 |  
 | 
			
				|  Enhancement Request = Ignore numbers |   |  
				| Right now it is just an idea/frustration.  In the where clause, I say column = 1<enter>, results in column = log10.  Why does it do that, because the intellisense sees 1 as part of the name of a command. 
 Some ideas:
 if the column is numeric/bit then don't provide a popup for numbers.
 don't do partial name or middle of name matches on commands or built-in functions
 
 Maybe someone else has a better implementation idea.
 
 |  |  
		| Thu Sep 12, 2013 10:54 am |     |  
		|  |  
		| SysOp Site Admin
 
 
 
 
			
				| Joined: 26 Nov 2006 Posts: 7990
 
 |  
 | 
			
				|   |   |  
				| I'm unable to reproduce that. Do you have log10 in the history part of the intellisense dialog when you type "column = 1" ? 
 |  |  
		| Thu Sep 12, 2013 9:33 pm |     |  
		|  |  
		| judahr 
 
 
 
 
			
				| Joined: 09 Mar 2007 Posts: 320
 Country: United States
 |  
 | 
			
				|   |   |  
				| No history is turned off. But I do have commands. 
 |  |  
		| Thu Sep 12, 2013 10:37 pm |     |  
		|  |  
		| gemisigo 
 
 
 
 
			
				| Joined: 11 Mar 2010 Posts: 2175
 
 |  
 | 
			
				|   |   |  
				| I'm able to reproduce it, and no, it's not a history item, log10 is a built-in function in MSSQL. I support the idea that expressions starting with number should be left alone. 
 |  |  
		| Fri Sep 13, 2013 10:22 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
 
 |  |  |