When No Text - Up Arrow to close suggestion window

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

When No Text - Up Arrow to close suggestion window

Postby sdingle » Fri Apr 25, 2014 12:13 pm

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
sdingle
 
Posts: 2
Joined: Fri Feb 22, 2013 12:14 pm

Postby Anu Deshpande » Mon Apr 28, 2014 10:51 am

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

Recepi

Postby hansmank » Thu May 22, 2014 3:39 pm

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.

Hans
hansmank
 
Posts: 4
Joined: Wed Dec 13, 2006 8:41 am
Location: Zwolle, the Netherlands

Postby Aaron Law » Fri May 23, 2014 10:00 am

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?

Thanks,
Aaron.
Aaron Law
 
Posts: 262
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby hansmank » Fri May 23, 2014 12:03 pm

Still pops-up.
No difference.
hansmank
 
Posts: 4
Joined: Wed Dec 13, 2006 8:41 am
Location: Zwolle, the Netherlands

Postby Aaron Law » Fri May 23, 2014 12:53 pm

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.
Aaron Law
 
Posts: 262
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 1 guest