Toad World® Forums

FW: Moving Cursor in editor up and down cause Program fault in Toad-SS 5.0.0.444 [1 Attachment]


#1

[ Attachment(s) from Hank Freeman MSN included below]

Toad-ss version 5.0.0.444 faults on simply moving cursor up and down, while
typing in an editor session

Message : startIndex cannot be larger than length of string.

This seems to be a consistent theme where Auto-complete is getting all twisted
up.

Below is the sql statement and it the cursor was on the set command.

use potentia

go

declare @var_Column_ Name nvarchar( 50 )

set @var_Column_ Name =

(

select [name] from sys.columns

where Name = N ‘DEPOSITCCNumber’

and Object_ID = Object_ID (N ‘Potentia.dbo. EnrollCustomerPa ymentInfo’ )

)

select @var_Column_ Name

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary

image001.gif

image002.jpeg


#2

Hmm, can’t seem to replicate this issue either. Is the cursor on the actual
“set” word or somewhere else in that statement?

/Mauritz
image002.jpeg


#3

Hmm, can’t seem to replicate this issue either. Is the cursor on the actual
“set” word or somewhere else in that statement?

/Mauritz
image001.gif


#4

The cursor was set right after the = sign….

use potentia

go

declare @var_Column_ Name nvarchar( 50 )

set @var_Column_ Name = (Cursor was here)

(

select [name] from sys.columns

where Name = N ‘DEPOSITCCNumber’

and Object_ID = Object_ID (N ‘Potentia.dbo. EnrollCustomerPa ymentInfo’ )

)

select @var_Column_ Name

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary
image002.jpeg


#5

The cursor was set right after the = sign….

use potentia

go

declare @var_Column_ Name nvarchar( 50 )

set @var_Column_ Name = (Cursor was here)

(

select [name] from sys.columns

where Name = N ‘DEPOSITCCNumber’

and Object_ID = Object_ID (N ‘Potentia.dbo. EnrollCustomerPa ymentInfo’ )

)

select @var_Column_ Name

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary
image001.gif