I am using the code completion feature in the editor, but I am getting odd results when I have () in the code.
The first query will offer the correct list and let you select from the list when typing line 5 (AND dd.Actu...). You can scroll and the list will automatically highlight a suggestion as you filter your choice by typing in a partial name. "AND dd.Actu" will bring you to column ActualDate.
SELECT TOP 1000 mf.*
FROM mkm.dbo.Datezone dd
INNER JOIN mkm.dbo.MonthlyFact mf
ON mf.IDKey = dd.IDKey
AND dd.ActualDate = '2008/08/05'
But, it looks like if there are parenthesis the code completion feature gets thrown off. This second query will offer you a correct list again, but you cannot interact with it in the same way. I can scroll and select but it will not filter down to what I need as I type. When typing line 5, "AND dd.Actu" will not highlight the correct column ActualDate.
SELECT TOP 1000 mf.*
FROM mkm.dbo.Datezone dd
INNER JOIN mkm.dbo.MonthlyFact mf
ON (mf.IDKey = dd.IDKey)
AND dd.ActualDate = '2008/08/05'
Issue related () used in the code and to the View | Option | Editor | Code Completion setting of "Merge secondary items". If this is enabled, it will chance the code completion popup list and cause the filtering to jump, skipping the columns names.
WORKAROUND 1:
Go to View | Option | Editor | Code Completion and disable "Merge secondary items". If there are () in the code, it will still be necessary to manually scroll up and down the list to the needed object to be selected. There is still a defect with the way filtering as you type works when there are (), but disabling this option will not make the highlighting to jump.
WORKAROUND 2:
Leave option enabled, but there is still a defect with the way filtering as you type works when there are () so it will still be necessary to manually scroll up and down the list to the needed object to be selected.
STATUS:
Waiting for fix in a future version of Toad for SQL Server.
There is still an issue with code completion adding an additional object name/alias when selecting from the drop down while the code has (). This has been reported and is also waiting for fix under the same Defect ID. Please refer to SOL46278 for more information.
