How can we help you today? How can we help you today?

Should SPACE be used to select candidates by default?

A contentious issue here. Should SPACE be one of the default keys used to select candidates from the drop down list (you can turn this off in the Options dialog btw)?

Personally for SQL intellisense in a language where whitespace characters are perfectly permissible within identifiers (unlike say C#) I think using SPACE to select an item from the candidate drop-down isn't a very good idea because it means you can never select any candidates with whitespace in them from the candidate list. It also seems to result in quite a high level of random crud being inserted into your SQL script. To be honest I find it annoying enough with Resharper when writing C#, with SQL it's absolutely maddening.

However, rather than make an executive decision and just have that box unchecked in the Options dialog by default, I thought it might be better to leave the decision to the people who are actually using SQL Prompt. So... what you YOU think?


Thanks,
Bart
Bart Read
0

Comments

15 comments

  • Bart Read
    BTW I should point out that since it is configurable it probably doesn't matter that much, however the five of us currently working on SQL Prompt 3 have engaged in a "robust discussion" about this issue already this morning so it would be interesting to know what the rest of you think.
    Thanks,
    Bart
    Bart Read
    0
  • rjpaulsen
    I would suggest not making it the default.
    rjpaulsen
    0
  • Bart Read
    Please don't all feel you have to say no to this: I'm now being accused by my colleagues of biasing the poll result with my post. :shock:
    Bart Read
    0
  • PDinCA
    Your presented scenarios make it sensible to not have it as a default out of the box. With it being so simple to turn the option on or off, it shouldn't matter either way. Perhaps you could add a "don't care either way" button to the poll... :wink:
    PDinCA
    0
  • rjpaulsen
    I feel like I was forced to agree. I want a recount.
    rjpaulsen
    0
  • lysp
    I personally would like to see it turned on.

    Its especially useful for parts where you'd always use the auto-completion.

    Eg.

    INNER JOIN[space]

    or
    INNER JOIN Table T ON[space]

    But this would depend on the candidate list showing up only when its needed. If it shows up othertimes i can see an argument for turning it off.
    lysp
    0
  • sangha
    I do not thinks it matters. If it was to cause me any problems I would go to options and just turn it off.
    sangha
    0
  • emails4me
    ditto..same as sangha.
    emails4me
    0
  • Bart Read
    I'm inclined to agree that it doesn't really matter since you can change it from the Options dialog, however this does raise another question... which I'll post another poll about shortly.
    Cheers,
    Bart
    Bart Read
    0
  • harriyott
    I'd definitely like the space bar enabled. I seem to remember it being enabled in version 2, so I've come to expect it. As I'd normally type a space, then it would be useful to me.
    harriyott
    0
  • Lumbago
    I think having space by itself displaying the candidate list is a little "overkill" and it's just annoying. However, if it pops up after a space in combination with a keyword like "FROM" or "ON" it would be alot better...
    Lumbago
    0
  • calloncampbell
    I posted a comment on this already but I'll engage in this discussion and say that I dont like the default of any of the completion keys with the exception of ENTER and TAB.

    Too many times have I gotten the wrong SQL or SQL when I didn;t want SQL when I pressed either SPACE or DOT...PARENTHESES most likely too.

    Just my 2 cents. I would turn off all but ENTER and TAB and if you can, maybe provide reasons on why and when we would use the other keys?

    Thanks

    Callon
    calloncampbell
    0
  • rauldiaz
    I vote for TAB and/or ENTER being selected by default and all others being up to the user.
    rauldiaz
    0
  • brian26ny
    I personally like the TAB. But I wouldn't be bothered by the SPACE bar as long as there is an option to change it.
    brian26ny
    0
  • nanchen
    Hello,

    I do vote for TAB and ENTER as default, and all others as optional. (I think this is also the standard behaviour of intellisense in VS).

    With kind regards,

    Emmanuel
    nanchen
    0

Add comment

Please sign in to leave a comment.