SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Anomaly: unwanted behavior when updating joined tables

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Anomaly: unwanted behavior when updating joined tables
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2100

Post Anomaly: unwanted behavior when updating joined tables Reply with quote
I have the following situation:
Code:

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:
Code:

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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
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 View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
Is this going to be released or beta'd soon?
Mon Jun 06, 2011 8:43 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.