Red Gate forums :: View topic - SQL Prompt 6.0.0.412 EAP - Object reference not set
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

SQL Prompt 6.0.0.412 EAP - Object reference not set

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
atompkins



Joined: 05 Jul 2011
Posts: 13

PostPosted: Tue Aug 27, 2013 4:19 pm    Post subject: SQL Prompt 6.0.0.412 EAP - Object reference not set Reply with quote

Object reference not set to an instance of an object. (Microsoft.VisualStudio.Editor.Implementation)

SSMS 2012 11.0.3128.0


I use solutions and projects within those solutions. The one I'm currently working on has 13 projects. If I open a .sql script file from a project, close it and then try to open it again I get the above error. If I close the solution and reopen I can open the .sql file once again but only once. I am going to have to go back to using v5 as this is limiting.

I am wondering if this has anything to do with the new Tab History button. It seems quite useful except that it opens individual .sql files on startup instead of the solution/project they belong to. SSMS creates a blank/fake solution file for them all to live in. They get closed when I open my solution anyway.
Back to top
View user's profile Send private message
blitzd



Joined: 26 Nov 2010
Posts: 32

PostPosted: Tue Aug 27, 2013 9:02 pm    Post subject: Reply with quote

I'm also having this issue, I just tracked it back to SQL Prompt 6 EAP mere moments ago. I am also using a solution, with many projects.

I have found that the tab history option appears to make a mess of things when the tabs you may have had open were a part of a solution, as it does NOT re-open the old solution, and instead adds them to the new default solution that SSMS creates. When this occurs to scripts that are in solutions/projects under source control it gets very messy - and that seems to be where the object references errors are coming from for me most of the time.
Back to top
View user's profile Send private message
ahmannj



Joined: 06 Jan 2006
Posts: 13
Location: Minneapolis, MN. USA

PostPosted: Tue Aug 27, 2013 9:57 pm    Post subject: Reply with quote

Also seeing this problem today in SSMS 2012, also with a solution with several projects. This happens for me when reopening a file within one of those projects that was modified outside of SSMS (in VS, actually)
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 222
Location: Red Gate Software

PostPosted: Wed Aug 28, 2013 9:24 am    Post subject: Reply with quote

Thanks for reporting this I can recreate it and will look into a fix for you.

In the meantime if this is interfering with your work you can disable the tab history feature by seting the <Enabled> variable to false in
%localappdata%\SQL Prompt 6\RedGate_SQLPrompt_CommonUI_Options_TabMagicOptions.xml
Back to top
View user's profile Send private message
atompkins



Joined: 05 Jul 2011
Posts: 13

PostPosted: Wed Aug 28, 2013 12:08 pm    Post subject: Reply with quote

Workaround confirmed, thanks Aaron.
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 222
Location: Red Gate Software

PostPosted: Thu Aug 29, 2013 8:54 am    Post subject: Reply with quote

I've just uploaded 6.0.0.435 which has a fix for the null reference exception. You can get it from check for updates in prompt or download from here.

Blitzd: we've also changed the behaviour so prompt won't automatically reopen queries belonging to a project/solution on startup.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group