Suggestions drop down not recognizing down press on join

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

Suggestions drop down not recognizing down press on join

Postby meyerovb » Fri May 25, 2012 3:22 pm

"select * from thing1"[enter]
"join thing2 on "

As soon as I type space the suggestions box appears with the correct join, however if I press down immediately it doesn't recognize it. I need to wait a second before pressing it, or press it a second time, in order for it to select the first auto-suggest item.

This is getting annoying because I automatically press down+enter because this worked in the last version fine on my system, now it sends me to the next line and i have to go back and press space again to get the suggestions list back up.
meyerovb
 
Posts: 13
Joined: Thu Dec 09, 2010 1:04 am

Postby Chris Auckland » Mon May 28, 2012 3:11 pm

Thanks for your post.

By default, there is a 300 millisecond delay before the suggestion is triggered.

Could you try decreasing this delay and see if that helps?

You can set it through SQL Prompt 5 > Options > Behaviour > Triggering Behaviour
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Re:

Postby meyerovb » Mon May 28, 2012 3:15 pm

Chris Auckland wrote:Thanks for your post.

By default, there is a 300 millisecond delay before the suggestion is triggered.

Could you try decreasing this delay and see if that helps?

You can set it through SQL Prompt 5 > Options > Behaviour > Triggering Behaviour


The suggestion box appears just fine, clicking the down key immediately after it appears doesn't seem to function. But I'll try that anyways tomorrow to see if it helps.
meyerovb
 
Posts: 13
Joined: Thu Dec 09, 2010 1:04 am

Postby Chris Auckland » Mon May 28, 2012 3:33 pm

I think I could sort of reproduce the problem you're having with a 300 ms delay, but with a 1 ms delay I couldn't type fast enough for the join selection to not be noticed.

Try it out when you get the chance; it seemed to help for me.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby kh_777 » Mon Oct 15, 2012 9:02 pm

I am also very annoyed by this behavior even with a 1 ms delay set. I've found that it never happens when pressing ctrl + space, but it always happens after typing ON or AND and then pressing the down key. If I wait for a second it works just like meyerovb mentioned. I find that I hit down once hit enter and then have to press ctrl + space because it didn't select anything.

This was not a problem in the previous version. Can you please add this to the list of things to fix?
kh_777
 
Posts: 1
Joined: Mon Oct 15, 2012 8:50 pm

Postby wdhenrik » Thu Nov 01, 2012 9:40 pm

I completely agree that this bug needs to be fixed.

I don't want to change the delay because there are many times I do not want it to popup immediately and 300ms delay is reasonable enough for that.

This bug almost seems like SQLPrompt is rendering the suggestions list twice as I can occasionally highlight the top item in the list using the down arrow keys, but it will be de-selected a moment later and I'll have to press the down arrow again. Please fix.
wdhenrik
 
Posts: 12
Joined: Thu Jul 19, 2012 11:58 pm

Postby Mikeh » Wed Jan 09, 2013 9:32 pm

To clarify, this issue can be readily demonstrated in SQL Prompt 5.3.6.28.

Open Query window in SSMS 11.0.2100.60

Type
CREATE TABLE #Table1 (mykey INT, yourkey INT, thekey int)
CREATE TABLE #table2 (mykey INT, yourkey INT, nokey int)

Type
SELECT *
FROM #Table as T
JOIN

Now pretend you know these tables and you know how they appear in the list. As soon as you type JOIN and press the space bar, SQL Prompt will draw a selection box. As soon as you see it pop, you press the down arrow twice to select the second item from the list (#table2) and then tab to select it.

You see the highlight first highlight the first row and you expect it to highlight the 2nd row so you press tab shortly after pressing the down arrow the second time. But what happens is that a tab is entered in the screen, and the SQL Prompt selection box re-draws itself to the right slightly and you can see the selection leave the 1st row, never making it to the 2nd row.

Now if you plod along and go slow, this issue is not exposed. But if you go rapidly, it occurs.

Note this is a behavior change from previous versions (don't know when it changed) as I know that for a long time I was having no issues, and then one day I started having issues. Most often it occurs on the join condition, since you get used to the join you want is always the second one it suggests. It's almost like it is not seeing the 2nd down arrow keypress before it gets the tab or it's missing the 1st down arrow keypress and only acting on the 2nd.
Mikeh
 
Posts: 7
Joined: Tue May 17, 2011 5:37 pm
Location: Minneapolis, MN

Postby blitzd » Wed Jan 16, 2013 7:51 pm

Also having this issue, and it's quite annoying. I often have to re-trigger the auto-suggest manually and pick, because it never works properly the first time when it's triggered automatically - it'll highlight the first suggestion for a fraction of a second, but then it removes it.
blitzd
 
Posts: 32
Joined: Fri Nov 26, 2010 7:30 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests