 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
[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: 7948
|
|
|
|
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
|
|
|