SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Update SET adding the ?

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Update SET adding the ?
Author Message
judahr



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

Post Update SET adding the ? Reply with quote
Update SET adds the ? for the columns. This behavior is different from the rest of the tool. Is there a way to turn it off?
Fri Jan 08, 2010 3:35 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
It is actually the same as in insert if you don't expand the column list.
If you don't want this to be done in one step and pasting ? symbols, use Shift+Enter when selecting object name, then type SET keyword and use column list with check-boxes
Fri Jan 08, 2010 5:00 pm View user's profile Send private message
judahr



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

Post Reply with quote
Actually in 4.8.29.

Assuming:

Update dbo.Table
Set

When you press Space you get the popup with columns. When you choose one or more columns with the keyboard it inserts the ?
Fri Jan 08, 2010 5:55 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
What would you like to see instead of the question mark?
Fri Jan 08, 2010 7:09 pm View user's profile Send private message
judahr



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

Post Reply with quote
just

column= ,
Sat Jan 09, 2010 9:17 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
I guess different people could have different preferences. This should be a customizable option.

In my opinion using "?" is better than nothing. For long tables having lots of columns and for complex queries, a missing value could be difficult to spot. On the other hand, "?" symbol allows the background syntax checker underline the missing values where they are missing, while a missing value leads to a overall syntax error and typically just makes the syntax checker (the database server engine) to reject the entire SQL statement as invalid and refer to the first keyword in that statement as a place of error. Now imagine your table is having 200 columns, and the UPDATE contains simple value assignments as well as expressions and subqueries. You would need to eye ball 3 to 4 pages of code just to find the missing value.
Sat Jan 09, 2010 1:35 pm 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.