Toad World® Forums

FW: TOAD-SS-Beta 5.0.0.414 --> SQL Editor session faults on syntax to Set a local variable when the @ value is typed. [1 Attachment]


#1

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

Declared a variable at the beginning of the script and gave it an initial value.

Attempted to set the Variable to another value at line 194 and Toad-ss-Beta 414
faults on typing the literal SET @… Meaning faulted on the @…

This was a previously reported problem, that I thought had been resolved… So I
am wondering if all th previous updates to fix have been applied.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary

Not Sure if this can be reproduced but here is what I did…

Declare a variable at the beginning and gave it an initial value.

Attempted to set the Variable to another value and Toad-ss-Beta 414 faults on
typing the liter SET @… Meaning faulted on the @…

This was a previously reported problem, that I thought had been resolved… So I
am wondering if all th previous updates to fix have been applied.


Exception Information


Exception: System.ArgumentOutO fRangeException

Message : 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,
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)


Support Bundle for Toad for SQL Server Beta 5.0 6/16/2010 4:06:16 PM



System Information


Operating System

Microsoft Windows 7 Professional 6.1.7600 AMD64

Manufacturer: Microsoft Corporation

Computer Name: HFREEMAN-D

Windows Directory: C:\Windows

Computer System

Computer Manufacturer Name: Hewlett-Packard

Computer Model: HP xw4400 Workstation

System Type: x64-based PC

Total Physical Memory: 8,388,032 KB

Domain: viterrausa.com

User Name: RKARCHER\hfreeman

System Processor

Manufacturer: GenuineIntel

Computer Processor: Intel64 Family 6 Model 15 Stepping 6

CPU Speed: 1.867 GHz

L2 Cache Size: 2 KB

System Bios

BIOS: Default System BIOS

BIOS Version: COMPAQ - 20060928

System Time Zone

Time Zone: (UTC-05:00) Eastern Time (US & Canada)

Logical Memory Configuration


Connection Information


Current Connection:

DevSQL.eso.local\ sql02 (RKARCHER\hfreeman) , master

Category: Development

SQL Server database

Server version 9.0.4266.0

Connected since 6/16/2010 10:27:40 AM

0 of 5 connections in pool active



SQL Server Registry Information - 2005 Debugging Configuration



HKEY_CLASSES_ ROOT\CLSID\ {87BC18DB- C8B3-11D5- AE96-00B0D0E93CC 1}

= PSFactoryBuffer

HKEY_CLASSES_ ROOT\CLSID\ {87BC18DB- C8B3-11D5- AE96-00B0D0E93CC
1}\InprocServer3 2

= c:\Program Files (x86)\Common Files\Microsoft Shared\SQL Debugging\ssdebugps
.dll

ThreadingModel= Both

( FileVersion: 2007.0100. 1600.022 ((SQL_PreRelease) .080709-1414 )
InternalName: SSDEBUGPS CompanyName: Microsoft Corporation )

HKEY_CLASSES_ ROOT\Interface\ {87BC18DB- C8B3-11D5- AE96-00B0D0E93CC 1}

= IHostDebugDebuggerI nstance

HKEY_CLASSES_ ROOT\Interface\ {87BC18DB- C8B3-11D5- AE96-00B0D0E93CC
1}\NumMethods

= 4

HKEY_CLASSES_ ROOT\Interface\ {87BC18DB- C8B3-11D5- AE96-00B0D0E93CC
1}\ProxyStubClsi d32

= {87BC18DB-C8B3- 11D5-AE96- 00B0D0E93CC1}

HKEY_CLASSES_ ROOT\Interface\ {87BC18DC- C8B3-11D5- AE96-00B0D0E93CC 1}

= IHostDebugServerIns tance

HKEY_CLASSES_ ROOT\Interface\ {87BC18DC- C8B3-11D5- AE96-00B0D0E93CC
1}\NumMethods

= 5

HKEY_CLASSES_ ROOT\Interface\ {87BC18DC- C8B3-11D5- AE96-00B0D0E93CC
1}\ProxyStubClsi d32

= {87BC18DB-C8B3- 11D5-AE96- 00B0D0E93CC1}

HKEY_CLASSES_ ROOT\Interface\ {87BC18DD- C8B3-11D5- AE96-00B0D0E93CC 1}

= IHostDebugEvent

HKEY_CLASSES_ ROOT\Interface\ {87BC18DD- C8B3-11D5- AE96-00B0D0E93CC
1}\NumMethods

= 18

HKEY_CLASSES_ ROOT\Interface\ {87BC18DD- C8B3-11D5- AE96-00B0D0E93CC
1}\ProxyStubClsi d32

= {87BC18DB-C8B3- 11D5-AE96- 00B0D0E93CC1}

HKEY_CLASSES_ ROOT\Interface\ {87BC18DE- C8B3-11D5- AE96-00B0D0E93CC 1}

= IHostDebug

HKEY_CLASSES_ ROOT\Interface\ {87BC18DE- C8B3-11D5- AE96-00B0D0E93CC
1}\NumMethods

= 16

HKEY_CLASSES_ ROOT\Interface\ {87BC18DE- C8B3-11D5- AE96-00B0D0E93CC
1}\ProxyStubClsi d32

= {87BC18DB-C8B3- 11D5-AE96- 00B0D0E93CC1}

HKEY_CLASSES_ ROOT\Interface\ {87BC18DF- C8B3-11D5- AE96-00B0D0E93CC 1}

= IHostDebugBinary

HKEY_CLASSES_ ROOT\Interface\ {87BC18DF- C8B3-11D5- AE96-00B0D0E93CC
1}\NumMethods

= 6

HKEY_CLASSES_ ROOT\Interface\ {87BC18DF- C8B3-11D5- AE96-00B0D0E93CC
1}\ProxyStubClsi d32

= {87BC18DB-C8B3- 11D5-AE96- 00B0D0E93CC1}

HKEY_CLASSES_ ROOT\Interface\ {87BC18E0- C8B3-11D5- AE96-00B0D0E93CC 1}

= IEnumHostDebugSymbo l

HKEY_CLASSES_ ROOT\Interface\ {87BC18E0- C8B3-11D5- AE96-00B0D0E93CC
1}\NumMethods

= 8

HKEY_CLASSES_ ROOT\Interface\ {87BC18E0- C8B3-11D5- AE96-00B0D0E93CC
1}\ProxyStubClsi d32

= {87BC18DB-C8B3- 11D5-AE96- 00B0D0E93CC1}



@@Version



9.0.4266.0

Connection:

sql06 (hfreeman), master

Category: Production

SQL Server database

Server version 9.0.4266.0

Connected since 6/16/2010 2:09:21 PM

0 of 1 connection in pool active

Connection:

QACRSQL.eso. local\SQL02 (RKARCHER\hfreeman) , master

Category: QACC

SQL Server database

Server version 9.0.4266.0

Connected since 6/16/2010 2:18:20 PM

0 of 2 connections in pool active


Loaded Assemblies


Accessibility, Version=2.0. 0.0, Culture=neutral, PublicKeyToken=
b03f5f7f11d50a3a C:\Windows\assembly \GAC_MSIL\ Accessibility\ 2.0.0.0__
b03f5f7f11d50a3a \Accessibility. dll

ActiproSoftware. Shared.Net20, Version=1.0. 103.0, Culture=neutral,
PublicKeyToken= 36ff2196ab5654b9 C:\Windows\assembly \GAC_MSIL\ ActiproSoftware.
Shared.Net20\ 1.0.103.0_ _36ff2196ab5654b 9\ActiproSoftwar e.Shared. Net20.dll

ActiproSoftware. SyntaxEditor. Net20, Version=4.0. 284.0, Culture=neutral,
PublicKeyToken= 21a821480e210563 C:\Windows\assembly \GAC_MSIL\ ActiproSoftware.
SyntaxEditor. Net20\4.0. 284.0__21a821480 e210563\ActiproS oftware.SyntaxEd
itor.Net20. dll

ActiproSoftware. UIStudio. Dock.Net20, Version=2.0. 109.0, Culture=neutral,
PublicKeyToken= be939c973e8cb8a6 C:\Windows\assembly \GAC_MSIL\ ActiproSoftware.
UIStudio. Dock.Net20\ 2.0.109.0_ _be939c973e8cb8a 6\ActiproSoftwar e.UIStudio.
Dock.Net20. dll

ActiproSoftware. WinUICore. Net20, Version=1.0. 103.0, Culture=neutral,
PublicKeyToken= 1eba893a2bc55de5 C:\Windows\assembly \GAC_MSIL\ ActiproSoftware.
WinUICore. Net20\1.0. 103.0__1eba893a2 bc55de5\ActiproS oftware.WinUICor
e.Net20.dll

DevExpress.BonusSki ns.v9.3, Version=9.3. 3.0, Culture=neutral, PublicKeyToken=
95fc6c5621878f0a C:\Windows\assembly \GAC_MSIL\ DevExpress. BonusSkins.
v9.3\9.3. 3.0__95fc6c56218 78f0a\DevExpress .BonusSkins. v9.3.dll

DevExpress.Data. v9.3, Version=9.3. 3.0, Culture=neutral, PublicKeyToken=
b88d1754d700e49a C:\Windows\assembly \GAC_MSIL\ DevExpress. Data.v9.3\ 9.3.3.0__
b88d1754d700e49a \DevExpress. Data.v9.3. dll

DevExpress.OfficeSk ins.v9.3, Version=9.3. 3.0, Culture=neutral, PublicKeyToken=
95fc6c5621878f0a C:\Windows\assembly \GAC_MSIL\ DevExpress. OfficeSkins.
v9.3\9.3. 3.0__95fc6c56218 78f0a\DevExpress .OfficeSkins. v9.3.dll

DevExpress.Utils. v9.3, Version=9.3. 3.0, Culture=neutral, PublicKeyToken=
b88d1754d700e49a C:\Windows\assembly \GAC_MSIL\ DevExpress. Utils.v9. 3\9.3.3.0_
_b88d1754d700e49 a\DevExpress. Utils.v9. 3.dll

DevExpress.XtraBars .v9.3, Version=9.3. 3.0, Culture=neutral, PublicKeyToken=
b88d1754d700e49a C:\Windows\assembly \GAC_MSIL\ DevExpress. XtraBars. v9.3\9.3.
3.0__b88d1754d70 0e49a\DevExpress .XtraBars. v9.3.dll

DevExpress.XtraEdit ors.v9.3, Version=9.3. 3.0, Culture=neutral, PublicKeyToken=
b88d1754d700e49a C:\Windows\assembly \GAC_MSIL\ DevExpress. XtraEditors.
v9.3\9.3. 3.0__b88d1754d70 0e49a\DevExpress .XtraEditors. v9.3.dll

DevExpress.XtraGrid .v9.3, Version=9.3. 3.0, Culture=neutral, PublicKeyToken=
b88d1754d700e49a C:\Windows\assembly \GAC_MSIL\ DevExpress. XtraGrid. v9.3\9.3.
3.0__b88d1754d70 0e49a\DevExpress .XtraGrid. v9.3.dll

DevExpress.XtraTree List.v9.3, Version=9.3. 3.0, Culture=neutral,
PublicKeyToken= b88d1754d700e49a C:\Windows\assembly \GAC_MSIL\ DevExpress.
XtraTreeList. v9.3\9.3. 3.0__b88d1754d70 0e49a\DevExpress .XtraTreeList.
v9.3.dll

FastData, Version=3.0. 0.414, Culture=neutral, PublicKeyToken= c862883b2ae69822
C:\Program Files (x86)\Quest Software\Toad for SQL Server Beta 5.0\FastData. dll

FlexCel, Version=5.1. 0.0, Culture=neutral, PublicKeyToken= cb8f6080e6d5a4d6
C:\Program Files (x86)\Quest Software\Toad for SQL Server Beta 5.0\FlexCel. dll

ICSharpCode. SharpZipLib, Version=0.85. 5.452, Culture=neutral, PublicKeyToken=
1b03e6acf1164f73 C:\Program Files (x86)\Quest Software\Toad for SQL Server Beta
5.0\ICSharpCode. SharpZipLib. dll

ManagedQP5, Version=5.2. 5.414, Culture=neutral, PublicKeyToken=
c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for SQL Server Beta
5.0\managedqp5. dll

Microsoft.Office. Interop.Excel, Version=12.0. 0.0, Culture=neutral,
PublicKeyToken= 71e9bce111e9429c C:\Windows\assembly \GAC\Microsoft.
Office.Interop. Excel\12. 0.0.0__71e9bce11 1e9429c\Microsof t.Office.
Interop.Excel. dll

Microsoft.Office. Interop.Outlook, Version=12.0. 0.0, Culture=neutral,
PublicKeyToken= 71e9bce111e9429c C:\Windows\assembly \GAC\Microsoft.
Office.Interop. Outlook\12. 0.0.0__71e9bce11 1e9429c\Microsof t.Office.
Interop.Outlook. dll

MLangLib, Version=1.0. 0.0, Culture=neutral, PublicKeyToken= c862883b2ae69822
C:\Program Files (x86)\Quest Software\Toad for SQL Server Beta 5.0\MLangLib. dll

mscorlib, Version=2.0. 0.0, Culture=neutral, PublicKeyToken= b77a5c561934e089
C:\Windows\Microsof t.NET\Framework\ v2.0.50727\ mscorlib. dll

msvcm90, Version=9.0. 30729.4926, Culture=neutral, PublicKeyToken=
b03f5f7f11d50a3a C:\Windows\WinSxS\ x86_microsoft. vc90.crt_ 1fc8b3b9a1e18e3b
9.0.30729. 4926_none 508ed732bcbc0e5a \msvcm90. dll

office, Version=12.0. 0.0, Culture=neutral, PublicKeyToken= 71e9bce111e9429c
C:\Windows\assembly \GAC\office\ 12.0.0.0_ _71e9bce111e9429 c\office. dll

PresentationCore, Version=3.0. 0.0, Culture=neutral, PublicKeyToken=
31bf3856ad364e35 C:\Windows\assembly \GAC_32\Presenta tionCore\ 3.0.0.0__
31bf3856ad364e35 \PresentationCor e.dll

Quest.Compare. General.Sys, Version=4.6. 0.0, Culture=neutral, PublicKeyToken=
c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for SQL Server Beta
5.0\Plugins\ SqlServer\ Quest.Compare. General.Sys. dll

Quest.Compare. General.SysInter faces, Version=4.6. 0.0, Culture=neutral,
PublicKeyToken= c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for
SQL Server Beta 5.0\Plugins\ SqlServer\ Quest.Compare. General.SysInter
faces.dll

Quest.DataCompare. PL, Version=3.0. 0.0, Culture=neutral, PublicKeyToken=
c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for SQL Server Beta
5.0\Plugins\ Data Compare\Quest. DataCompare. PL.dll

Quest.PersistentCac he, Version=3.0. 0.414, Culture=neutral, PublicKeyToken=
c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for SQL Server Beta
5.0\Quest.Persisten tCache.dll

Quest.Schema. MSSQL.ComparePlu gin, Version=3.1. 0.101, Culture=neutral,
PublicKeyToken= null C:\Program Files (x86)\Quest Software\Toad for SQL Server
Beta 5.0\Plugins\ SqlServer\ Compare\Schema\ Quest.Schema. MSSQL.ComparePlu
gin.dll

Quest.VersionContro l, Version=1.1. 0.414, Culture=neutral, PublicKeyToken=
c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for SQL Server Beta
5.0\Quest.VersionCo ntrol.dll

QuestElevation, Version=1.0. 0.0, Culture=neutral, PublicKeyToken=
c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for SQL Server Beta
5.0\QuestElevation. exe

System, Version=2.0. 0.0, Culture=neutral, PublicKeyToken= b77a5c561934e089
C:\Windows\assembly \GAC_MSIL\ System\2. 0.0.0__b77a5c561 934e089\System. dll

System.Configuratio n, Version=2.0. 0.0, Culture=neutral, PublicKeyToken=
b03f5f7f11d50a3a C:\Windows\assembly \GAC_MSIL\ System.Configura tion\2.0.
0.0__b03f5f7f11d 50a3a\System. Configuration. dll

System.Core, Version=3.5. 0.0, Culture=neutral, PublicKeyToken= b77a5c561934e089
C:\Windows\assembly \GAC_MSIL\ System.Core\ 3.5.0.0__ b77a5c561934e089
\System.Core. dll

System.Data, Version=2.0. 0.0, Culture=neutral, PublicKeyToken= b77a5c561934e089
C:\Windows\assembly \GAC_32\System. Data\2.0. 0.0__b77a5c56193 4e089\System.
Data.dll

System.Design, Version=2.0. 0.0, Culture=neutral, PublicKeyToken=
b03f5f7f11d50a3a C:\Windows\assembly \GAC_MSIL\ System.Design\ 2.0.0.0__
b03f5f7f11d50a3a \System.Design. dll

System.Drawing, Version=2.0. 0.0, Culture=neutral, PublicKeyToken=
b03f5f7f11d50a3a C:\Windows\assembly \GAC_MSIL\ System.Drawing\ 2.0.0.0__
b03f5f7f11d50a3a \System.Drawing. dll

System.EnterpriseSe rvices, Version=2.0. 0.0, Culture=neutral, PublicKeyToken=
b03f5f7f11d50a3a C:\Windows\assembly \GAC_32\System. EnterpriseServic es\2.0.0.
0__b03f5f7f11d50 a3a\System. EnterpriseServic es.dll

System.Management, Version=2.0. 0.0, Culture=neutral, PublicKeyToken=
b03f5f7f11d50a3a C:\Windows\assembly \GAC_MSIL\ System.Managemen t\2.0.0.0_
_b03f5f7f11d50a3 a\System. Management. dll

System.Runtime. Serialization. Formatters. Soap, Version=2.0. 0.0,
Culture=neutral, PublicKeyToken= b03f5f7f11d50a3a C:\Windows\assembly \GAC_MSIL
System.Runtime. Serialization. Formatters. Soap\2.0. 0.0__b03f5f7f11d
50a3a\System. Runtime.Serializ ation.Formatters .Soap.dll

System.ServiceProce ss, Version=2.0. 0.0, Culture=neutral, PublicKeyToken=
b03f5f7f11d50a3a C:\Windows\assembly \GAC_MSIL\ System.ServicePr ocess\2.0.
0.0__b03f5f7f11d 50a3a\System. ServiceProcess. dll

System.Transactions , Version=2.0. 0.0, Culture=neutral, PublicKeyToken=
b77a5c561934e089 C:\Windows\assembly \GAC_32\System. Transactions\ 2.0.0.0__
b77a5c561934e089 \System.Transact ions.dll

System.Web, Version=2.0. 0.0, Culture=neutral, PublicKeyToken= b03f5f7f11d50a3a
C:\Windows\assembly \GAC_32\System. Web\2.0.0. 0__b03f5f7f11d50 a3a\System.
Web.dll

System.Windows. Forms, Version=2.0. 0.0, Culture=neutral, PublicKeyToken=
b77a5c561934e089 C:\Windows\assembly \GAC_MSIL\ System.Windows. Forms\2.0.
0.0__b77a5c56193 4e089\System. Windows.Forms. dll

System.Xml, Version=2.0. 0.0, Culture=neutral, PublicKeyToken= b77a5c561934e089
C:\Windows\assembly \GAC_MSIL\ System.Xml\ 2.0.0.0__ b77a5c561934e089
\System.Xml. dll

Toad, Version=5.0. 0.414, Culture=neutral, PublicKeyToken= c862883b2ae69822
C:\Program Files (x86)\Quest Software\Toad for SQL Server Beta 5.0\Toad.exe

ToadCore, Version=5.0. 0.414, Culture=neutral, PublicKeyToken= c862883b2ae69822
C:\Program Files (x86)\Quest Software\Toad for SQL Server Beta 5.0\ToadCore. dll

ToadDataCompareAndS ync, Version=3.0. 0.14, Culture=neutral, PublicKeyToken=
c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for SQL Server Beta
5.0\Plugins\ Data Compare\ToadDataCom pareAndSync. dll

ToadPlugin, Version=5.0. 0.414, Culture=neutral, PublicKeyToken=
c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for SQL Server Beta
5.0\ToadPlugin. dll

ToadSqlServer, Version=5.0. 0.414, Culture=neutral, PublicKeyToken=
c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for SQL Server Beta
5.0\Plugins\ SqlServer\ ToadSqlServer. dll

ToadSqlServerActivi ties, Version=5.0. 0.0, Culture=neutral, PublicKeyToken=
c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for SQL Server Beta
5.0\Plugins\ SqlServer\ ToadSqlServerAct ivities.dll

ToadSqlServerProvid er, Version=5.0. 0.414, Culture=neutral, PublicKeyToken=
c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for SQL Server Beta
5.0\Plugins\ SqlServer\ ToadSqlServerPro vider.dll

vlm34p15, Version=5.0. 0.414, Culture=neutral, PublicKeyToken= null

WindowsBase, Version=3.0. 0.0, Culture=neutral, PublicKeyToken= 31bf3856ad364e35
C:\Windows\assembly \GAC_MSIL\ WindowsBase\ 3.0.0.0__ 31bf3856ad364e35
\WindowsBase. dll

QP5, Version=5.159. 1006.15005, C:\Program Files (x86)\Quest Software\Toad for
SQL Server Beta 5.0\qp5.dll


Licensing


Trial

image001.gif

image002.jpeg

image003.jpeg