Toad World® Forums

autocomplete error


#1

enter a query in query editor using these steps

  1. select
  2. from dbo.sometable t
  3. where year(t.somedatefield) = someyear
  4. go back up to select and type t. to get error

Exception Information


Exception: System.ArgumentOutOfRangeException
Message : startIndex cannot be larger than length of string.
Parameter name: startIndex
Stack Trace:
at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy)
at Quest.Toad.CodeInsight.BaseDialect.GetInsight(IConnection connection, IParsable piece, ChunkInsight chunkInsight, Int32 offset, List1 tokens, Int32& position, Int32 lastToken, BlockInsight endBlock, String defaultSchema, Boolean filtering, Hashtable extraContext, ObjectInsight objectInsight) at Quest.Toad.CodeInsight.BaseDialect.GetInsight(IConnection connection, IParsable piece, ChunkInsight chunkInsight, Int32 offset, List1 tokens, Int32& position, Int32 lastToken, BlockInsight endBlock, String defaultSchema, Boolean filtering, Hashtable extraContext, ObjectInsight objectInsight)
at Quest.Toad.CodeInsight.BaseDialect.GetInsight(IConnection connection, IParsable piece, ChunkInsight chunkInsight, Int32 offset, List`1 tokens, Int32& position, Int32 lastToken, BlockInsight endBlock, String defaultSchema, Boolean filtering, Hashtable extraContext, ObjectInsight objectInsight)
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)


#2

This is the same bug several people are reporting. This is due to a change in
our parser and we are working to get an update. There are in infinite number of
ways to reproduce this bug but they are all basically the same. If you see this
error:

Message : startIndex cannot be larger than length of string.

And the top of the call stack looks like this:

at System.String. InternalSubStrin gWithChecks( Int32 startIndex, Int32 length,
Boolean fAlwaysCopy)
at Quest.Toad.CodeInsi ght.BaseDialect. GetInsight( IConnection connection,
IParsable piece, ChunkInsight chunkInsight, Int32 offset, List`1 tokens, Int32&

Then there is no need to report it any more. Thanks.