 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
Update SET adding the ? |
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
What would you like to see instead of the question mark?
|
|
Fri Jan 08, 2010 7:09 pm |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
just
column= ,
|
|
Sat Jan 09, 2010 9:17 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
|
|
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
|
|
|