What are the challenges you face when working across database platforms? Take the survey

When No Text - Up Arrow to close suggestion window

sdinglesdingle Posts: 15 New member
edited May 23, 2014 7:53AM in SQL Prompt
I had created a snippet for begin transaction (below to recreate). When the cursor is placed in between the BEGIN and COMMIT a suggestion window pops up, with no suggestion because there is no text there yet, and I find myself always closing for various reason . Just wondering if there is a setting that would turn this off. If not I was wondering if I could suggest it.

Basically I don't think this is common behaviour within SQL Prompt. If I place the cursor in the query window via mouse, enter, arrow key a suggestion window doesn't come up . This only seems to happen when the snippet window is run,placing a cursor and there is NO text or if I start typing then backspace removing all the text

Just a thought


  • Options
    Anu DAnu D Posts: 876 Silver 3
    Thanks for your post.

    Unfortunately I am not able to replicate the issue you are having.

    Is it possible for you to send us a screencast of this issue? We have logged a ticket for you so you will get an email and if you are using Zendesk portal you will get an option to create a screencast (video).

    This will help us understand the issue better and follow exact steps you are following.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    When typing sql script, like:

    Select * from SomeTable
    where cp = 5
    and field2 = 'test'

    When the cursor is behind the last line and you click Home to place the cursor in front of: and
    than click <enter> to open up a new line between the lines "where cp=5" and the line "and field2 = 'test'"
    Than the prompt window is activated in (all suggestions).
    Moving the cursor up, to go to the new line, places the cursor on "yell" of the code snippets.
    When you click tab, you get the AAAAAAARCH! tekst and you are frustrated :).

    If someone sees this behaviour depends on the formating end editing habbits, but for me it is very anoying.

  • Options
    Aaron LAaron L Posts: 596 New member
    Hi hansmank,

    We think we might have recreated what you're mentioning here but in a slightly odd way and wanted to confirm that it's the same issue you're seeing.

    In SSMS if you go to File->Advanced Save Options… and set the line endings to Windows (CR LF) does the suggestion window still popup?

  • Options
    Still pops-up.
    No difference.
  • Options
    Aaron LAaron L Posts: 596 New member
    Hmm in that case we are seeing something different.

    Would it be possible to set up a remote session with you so we can see the behaviour? If so, I'll send you an email with more details.
Sign In or Register to comment.