"Press TAB to insert snippet"

Provides intelligent code completion for SQL Server editors.

"Press TAB to insert snippet"

Postby PoppaRex » Fri Jul 09, 2010 7:10 pm

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
PoppaRex
 
Posts: 1
Joined: Fri Jul 09, 2010 6:49 pm

Postby Anu Deshpande » Mon Jul 12, 2010 1:24 pm

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: Select all
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
Anu Deshpande
 
Posts: 737
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests