| 
	
		| 
		
			|  | SoftTree Technologies Technical Support Forums
 |  |  
	
		| 
	
	
	
		| Author | Message |  
		| gemisigo 
 
 
 
 
			
				| Joined: 11 Mar 2010 Posts: 2175
 
 |  
 | 
			
				|  [SA 6 Beta] - UPDATE Intellisense vs. COMMIT/ROLLBACK & |   |  
				| The situation is the following: 
 
 
	|  |  
	|  | BEGIN TRANSACTION honolulu
 
 UPDATE   u
 SET u|
 FROM
 dbo.table_1 AS u
 
 --COMMIT TRANSACTION honolulu
 
 
 |  If the COMMIT line is uncommented, pressing '.' after 'SET u' does not trigger the popup. The same applies when replacing COMMIT with ROLLBACK.
 
 Also, when joining a table in the FROM section :
 
 
	|  |  
	|  | UPDATE   u
 SET   u.jel1 = u.jel2
 FROM
 dbo.table_1 AS u
 INNER JOIN
 dbo.table_2 AS t
 ON  t.id_table_1 = u.id_table_1 -- this one is selected from the popup for ON
 AND t.jel = u|
 
 |  Pressing '.' should get the popup with columns in u (table1) but it does not.
 
 |  |  
		| Fri Jul 01, 2011 7:41 am |     |  
		|  |  
		| SysOp Site Admin
 
 
 
 
			
				| Joined: 26 Nov 2006 Posts: 7990
 
 |  
 | 
			
				|   |   |  
				| Thank you. I have logged this issue to the tracking system, #SA0014804 
 |  |  
		| Fri Jul 01, 2011 8:06 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
 
 |  |  |