"Press TAB to insert snippet"

PoppaRexPoppaRex Posts: 2
edited July 12, 2010 8:24AM in SQL Prompt Previous Versions
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

Comments

  • Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post.

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

    Instead if you type:
    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: [email protected]
Sign In or Register to comment.