Snippet Description disappear

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

Snippet Description disappear

Postby rre » Thu May 24, 2012 2:58 pm

When I type a shortcut for a snippet e.g. ssf (very known shortcut) I get also the description of the snippet.

But unfortunately the description disappears from the dialog which appears when you type a shortcut since the last version(s).
The columns it's remove in general from the tooltip dialog?
I have to configure my SQL Prompt correctly?

I'm using the current version of SQLPrompt.
rre
 
Posts: 30
Joined: Thu Jul 07, 2011 2:13 pm

Postby Paul Stephenson » Fri May 25, 2012 8:14 am

Hi rre,

Do you mean where it says "SELECT * FROM fragment" in grey on the right of the suggestions box? I still see this text on my machine with SQL Prompt 5.3.2.2.

If the object definition box is missing (the extra box that flies out with the full expansion of the snippet) then ensure that "Display object definitions" in SQL Prompt 5 > Options... > Behavior is checked.

Regards,
Paul
Paul Stephenson
Project Manager, Red Gate
Paul Stephenson
 
Posts: 109
Joined: Fri Jul 23, 2010 9:22 am
Location: Cambridge, UK

Postby rre » Fri May 25, 2012 10:08 am

Yes, I mean the mean where it says "SELECT * FROM fragment" in grey on the right of the suggestions box. Any idea how I could show this description again?

The definition box is still there and very helpful. Thisworks fine.
rre
 
Posts: 30
Joined: Thu Jul 07, 2011 2:13 pm

Postby Paul Stephenson » Fri May 25, 2012 11:12 am

I'm sorry, that's not something we have ever seen before :( . In my copy this grey text is there fine. Could you post more details about your SSMS version?

If you uninstall and downgrade to the previous version 5.3.0.3, does the grey text come back again?

Thanks,
Paul
Paul Stephenson
Project Manager, Red Gate
Paul Stephenson
 
Posts: 109
Joined: Fri Jul 23, 2010 9:22 am
Location: Cambridge, UK

Postby rre » Fri Jun 01, 2012 8:56 am

I tried the mentioned method to uninstall and downgrade to the old version 5.3.0.3. But unfortunately the problem is not solved.
Any other ideas? I could also try to delete/rename my local SQL Prompt 5 configuration folder and install SQL Prompt afterwards again.

I'm using the SSMS 2008 Build 10.0.5500.0. Do you need any other information?
rre
 
Posts: 30
Joined: Thu Jul 07, 2011 2:13 pm

Postby Paul Stephenson » Fri Jun 01, 2012 10:33 am

That's very strange. Maybe one of the SQL Prompt local configuration files has got something wrong in it, so renaming the %LocalAppData%\\Red Gate\\SQL Prompt 5 out of the way could be worth a try. You won't need to reinstall SQL Prompt.

In that directory, RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml has an entry <CandidateListColumnDivider>, which controls how far across the grey text should start. Although the user interface shouldn't let you move the grey text completely out of the way, if something has caused this value to be outside the range of 0.125 to 0.875 then the grey text could disappear. For instance, I manually edited the value to 1.0 and couldn't see the grey text at all.

Renaming the directory as above will reset SQL Prompt's settings, but you could also take a look inside that XML file to see if there is an odd value there.
Paul Stephenson
Project Manager, Red Gate
Paul Stephenson
 
Posts: 109
Joined: Fri Jul 23, 2010 9:22 am
Location: Cambridge, UK

Postby Baldwin86 » Tue Jun 05, 2012 12:42 pm

Thank you Paul for the reply, it sounds way more simple to understand now.
I'll rename the directory to reset the settings.
Baldwin86
 
Posts: 1
Joined: Tue Jun 05, 2012 12:23 pm
Location: United States

Postby rre » Tue Jun 05, 2012 1:27 pm

Sorry, for the late response.

Thanks, Paul! It works fine, now. After changing the value for the entry CandidateListColumnDivider in the configuration file I see the description again.
rre
 
Posts: 30
Joined: Thu Jul 07, 2011 2:13 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests