, t.[object_id]
, t,.
When you type the dot after the t, in the line show above, you’ll get this exception:
System.ArgumentOutOfRangeException
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
Stack Trace:
at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
at System.ThrowHelper.ThrowArgumentOutOfRangeException()
at Quest.Toad.CodeInsight.LanguageDialect.ReadVirtualList(IConnection connection, Insight insight, IncludeInsight include, Boolean filtering, String defaultSchema)
at Quest.Toad.SqlServer.SqlServerLanguageDialect.ReadVirtualList(IConnection connection, Insight insight, IncludeInsight include, Boolean filtering, String defaultSchema)
at Quest.Toad.CodeInsight.BaseDialect.GenerateInsight(IConnection connection, String defaultSchema, Boolean filtering, Insight insight, Boolean secondary, Boolean& hasSecondary, List`1 ownerList)
at Quest.Toad.CodeInsight.BaseDialect.GetInsight(IConnection connection, Chunk chunk, Int32 offset, String defaultSchema, Int32& startOffset, Boolean& hasSecondary, Boolean filtering, Boolean secondary, HotTokenInsight hotToken)
at Quest.Toad.Editor.Commands.InvokeMemberListCommand.FetchMemberListItems(Object editorText)
When using Toad insight (the intellisense feature), if you accidentally type a comma, and then a dot when using a table alias, Toad throws an exception:
For example:SELECT t.[name]FROM sys.tables t
Darren
