Toad World® Forums

Error with editor and code complete?


#1

When I am typing the following code.

CREATE TABLE #MG(

[Owner] varchar NULL,

[CostCenter] varchar NULL,

[PrimaryRef] varchar NULL,

[Carrier] varchar NULL,

[LoadRef] varchar NULL,

[OriginCity] varchar NULL,

[OriginSt] varchar NULL,

[DestCity] varchar NULL,

[DestSt] varchar NULL,

[ActualShip] NULL,

[ActualDel] NULL,

[APAccrued] numeric(15, 5) NULL,

[APAccruedFuel] numeric(15, 5) NULL,

[ARAccrued] numeric(15, 5) NULL,

[ARAccruedMgmtFee] numeric(15, 5) NULL,

[ARAccruedFuel] numeric(15, 5) NULL,

[APInvNo] varchar NULL,

[APPostingDate] NULL,

[APPeriod] [int] NULL,

[APAmt] numeric(15, 5) NULL,

[APFuel] numeric(15, 5) NULL,

[ARInvNo] numeric(15, 5) NULL,

[ARPostingDate] NULL,

[ARPeriod] varchar NULL,

[ARAmt] numeric(15, 5) NULL,

[ARMgmtFee] numeric(15, 5) NULL,

[ARFuel] numeric(15,

[Funds] varchar NULL,

[RateType] varchar NULL,

[AP Note] varchar NULL,

[TenderedElgin] varchar NULL

) ON [PRIMARY]

I am inserting the line “[ARFuel]” I type “[ARFuel]
numeric(15,” and when I type the space after the comma, I get the error
shown below. I click OK and I can continue typing code.

System.ArgumentOutO fRangeException

Index and length must refer to a location within the string.

Parameter name: length

Stack Trace:

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&
position, Int32 lastToken, BlockInsight endBlock, String defaultSchema, Boolean
filtering, Hashtable extraContext, ObjectInsight objectInsight)

at Quest.Toad.CodeInsi ght.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.CodeInsi ght.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.CodeInsi ght.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. InvokeMemberList Command.FetchMem berListItems(
Object editorText)


#2

Matt,

Is it the latest 438 build you see this exception in?

Thanks,

Igor.


#3

This is 414……

Man, how did I miss that release.

Let me download 438 and see if it still happens.


#4

Yes, it was addressed in the latest beta. We also addressed some formatter
issues so it would be a good idea to check your formatter problem in the latest
beta too.

Igor.


#5

Igor,

Yes, this is fixed in build 438. Please disregard.

Sorry for the false alarm.

Thanks,

Matt


#6

I’m really glad the alarm was false J .

Igor.