 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
Anomaly: unwanted behavior when updating joined tables |
|
I have the following situation:
 |
 |
UPDATE t2
SET|
FROM
dbo.temp1 AS t1
INNER JOIN
dbo.temp2 AS t2
ON t2.id = t1.id
|
Pressing space behind SET I get a pop-up where I can select fields from both tables (I'd only need those from t2). After selecting one it is pasted with '= ?' so the result looks like:
 |
 |
UPDATE t2
SET t2.e = ?
FROM
dbo.temp1 AS t1
INNER JOIN
dbo.temp2 AS t2
ON t2.id = t1.id
|
There is an unwanted '= ?' there.
It also happens when updating a single table but it is much more inconvenient with joins where I could just select the field press '=' and select another. Instead of that now I have to select them and delete a pair of annoying '= ?'.
It would be nice to have that '= ?' removed from the result.
|
|
Thu Mar 31, 2011 9:22 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Enhancement #SA11659 has been already implemented and is going to be released with the next version. It addresses both issues, Intellisense for UPDATE ... FROM ... (and DELETE ... FROM...) and also extra question marks inserted in UPDATE FROM and related cases.
|
|
Fri Apr 01, 2011 8:18 pm |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
Is this going to be released or beta'd soon?
|
|
Mon Jun 06, 2011 8:43 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Please email to support to request the download link for the beta version (private beta is now running, full scale public beta will start soon)
|
|
Mon Jun 06, 2011 9:32 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
|
|
|