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.

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.

I'm seeing this in 3.1.24 within Query Analyzer.

I'm seeing this in 3.1.24 within Query Analyzer.

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.

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.

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.

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.