I was working with a SQL script in a VS 2008 database project (Win XP SP2, SQL Server 2005), and when I moved a cursor to a file editor window and hit a keyboard key (to type a word), I got the
'Object reference not set to an instance of an object' exception (I'm using SQL Prompt v. 3.8.0.224):

---
************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at RedGate.SqlPrompt.Engine.SqlPromptEngine.ParameterPrompt()
at RedGate.SQLPrompt.CommonUI.Editor.EditorWindowBase.OnCaretPoitionChanged()
at RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor.Microsoft.VisualStudio.OLE.Interop.IOleCommandTarget.Exec(Guid& pguidCmdGroup, UInt32 nCmdID, UInt32 nCmdexecopt, IntPtr pvaIn, IntPtr pvaOut)
---

It happens quite often, e.g. when I enter a space character or double-click . basically, it's next to impossible to use in a VS 2008 database project.
alekdavis
0

Comments

1 comment

  • alekdavis
    After restarting Visual Studio, the problem is gone. I've been working all day today and never got an error. :) I'll post an update if I see this again (hopefully not).
    alekdavis
    0

Add comment

Please sign in to leave a comment.