Author |
Message |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
Update Set and Where clauses are using 3 part notation |
|
v 3.1.19
After you type: Update Database.dbo.Table <enter> it properly outputs all columns in the table with the Set clause.
Clear away all the columns leaving Set.
Use Ctrl-Space to select a column. It outputs Database.dbo.Table.Column. It should output just the Column.
I've also seen this in the where clause:
Empty out the Set clause
Move to Where clause
Use Ctrl-Space to choose a column.
Outputs Database.dbo.Table.Column rather than just column.
|
|
Wed Mar 05, 2008 3:14 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7839
|
|
|
|
Thanks for the bug report. We got this issue fixed in 3.1.21 build, which we are still testing. This build could be made available as soon as tomorrow, assuming that major issues are found.
|
|
Wed Mar 05, 2008 3:50 pm |
|
![](templates/GreenTech/images/spacer.gif) |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
I'm seeing this in 3.1.24 within Query Analyzer.
|
|
Wed Mar 12, 2008 9:53 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7839
|
|
|
|
Please verify all DLLs in the Program Files\SQL Assistant\Data subfolder have the same date. I'm afraid you had some targets open during the installation and not all of them got updated. If you cannot delete these DLLs, something is still hanging and you may need to restart Windows to clear it.
|
|
Wed Mar 12, 2008 10:30 am |
|
![](templates/GreenTech/images/spacer.gif) |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
DLL's dated: 3/11/2008 6:50 PM
Uninstalled. Verified deletion. Reinstalled.
Update dbo.Table correctly outputs columns. Where pops up column list. Type in first few letters of desired column then hit enter. 3 part name shows.
|
|
Wed Mar 12, 2008 10:41 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7839
|
|
|
|
Oh... My misunderstanding…I thought your were referring to the issue with DDL commands.
I can reproduce it now, but only if I type the beginning of column name to filter the second level column list. If I simply click the needed column or select it using keyboard (no filtering), I get that column name only.
I'm going submit an issue that further improvements are needed for dealing with filtered column lists.
|
|
Wed Mar 12, 2008 10:55 am |
|
![](templates/GreenTech/images/spacer.gif) |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
DDL's are fine now. Thanks for the quick turnaround. Y, I noticed just using keyboard navigation didn't cause the error so I gave more specific repro steps.
|
|
Wed Mar 12, 2008 11:03 am |
|
![](templates/GreenTech/images/spacer.gif) |
|