[ 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.EnrollCustomerPaymentInfo’ )
)
select @var_Column_Name
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
hfreeman@msn.com
678.414.0090 my cell Primary


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

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

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.EnrollCustomerPaymentInfo’ )
)
select @var_Column_Name
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
hfreeman@msn.com
678.414.0090 my cell Primary

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.EnrollCustomerPaymentInfo’ )
)
select @var_Column_Name
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
hfreeman@msn.com
678.414.0090 my cell Primary
