Red Gate forums :: View topic - "Press TAB to insert snippet"
Return to www.red-gate.com RSS Feed Available

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

"Press TAB to insert snippet"

Search in SQL Prompt Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
PoppaRex



Joined: 09 Jul 2010
Posts: 1

PostPosted: Fri Jul 09, 2010 7:10 pm    Post subject: "Press TAB to insert snippet" Reply with quote

Hi all. New to this product. I am growing used to it but it will take me a bit longer. One feature(?) that i have trouble with... If my sql screen includes an "end" satement and i want to inset a snippet, there's a message box that pops up telling me that if i want to insert a snippet i shoud use the TAB key rather than the enter key, and the enter key just adds a new line.

Here's the condition. I have a snippet ssf which inserts "Select * from"

-- typing "ssf" here and using the enter key works normally
BEGIN
END
-- Typing "SSF" here i have a little yellow window prompt that says "Press TAB to insert snippet" and using the enter key adds a newline.


there are other scenarios but its all bizzare and seem to be related to where on the screen i am in relation to an end statement.

My options are set to use both tab and enter.

I did the following:
I removed the TAB option
closed SQL sver manager
relaunched SQL sver manager
checked the options (Still only ENTER selected.
Opened a window
typed ssf and the normal behavior ensured.
Typed "END" hit enter
Typed SSF and the yellow tab only box appears...

bug or am i doing something wrong?

Nothing critical as i just need to watch what i am typing, but it slows me down if i have to watch the screen.

Thanks!
Rob

Using v 4.0.3.12 with SQL Server 2005
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 662
Location: Cambridge

PostPosted: Mon Jul 12, 2010 1:24 pm    Post subject: Reply with quote

Many thanks for your post.

This happens because Management studio cannot parse the query hence SQL prompt behaves that way.

Instead if you type:

Code:

BEGIN   

SELECT * FROM <Table name>

END

ssf


And than press enter key it should work.

Kindly let me know your views on this.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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