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

Spacebar and candidate list

I have a couple of comments on how/when the candidate list appears when using the spacebar.

1. Is it possible to keep the candidate list displayed when changing the selected window in windows? Meaning, when I have dual monitors setup I want to be able to switch to a different application in the other monitor and still see the candidate list in the opposite monitor.

2. When pressing the spacebar the candidate list is displayed with the first item in the list selected. In my case it's "B" (without qoutes) as this is a table alias, but when I press "." to get the list of the tables columns I get only the "." entered in QA. Can this be made to show the columns instead of writing the "." to the window?

3. Why does the = key bring up the candidate list? If I'm typing a join or a where clause and I type the =. The candidate list is displayed and I then press the spacebar to make the space for the value. The first item in the candidate list is written instead of allowing the space that should go in between the = and the value. This only happens because I have the spacebar set as a completion key. I think the spacebar should be set to not work in certain places like when the = key is used. I need to be able to press the spacebar again to make a space for the value. After I press the = key and then the spacebar should bring up the candidate list.

4. I would like an option to use CTRL+J to get the candidate list so it's consistant with VS .Net.

Thank you for all the hard work. This is a much better product that the last version and will only get better with time.
mohaaron
0

Comments

4 comments

  • Tilman
    Hi,
    1. Is it possible to keep the candidate list displayed when changing the selected window in windows? Meaning, when I have dual monitors setup I want to be able to switch to a different application in the other monitor and still see the candidate list in the opposite monitor.

    I've added it to our list.
    2. When pressing the spacebar the candidate list is displayed with the first item in the list selected. In my case it's "B" (without qoutes) as this is a table alias, but when I press "." to get the list of the tables columns I get only the "." entered in QA. Can this be made to show the columns instead of writing the "." to the window?

    Have you enabled '.' as a completion key? (Options>Candidates>Completion Keys) You also need to turn on 'Show objects for specified owner or schema' on the same tab. (NB: Need to refresh the cached db when changing this option.)
    3. Why does the = key bring up the candidate list? If I'm typing a join or a where clause and I type the =. The candidate list is displayed and I then press the spacebar to make the space for the value. The first item in the candidate list is written instead of allowing the space that should go in between the = and the value. This only happens because I have the spacebar set as a completion key. I think the spacebar should be set to not work in certain places like when the = key is used. I need to be able to press the spacebar again to make a space for the value. After I press the = key and then the spacebar should bring up the candidate list.

    Welcome to the world of space completion. It's a tricky subject and it will be impossible to please everyone. Apart from that, strictly speaking you don't have to put a space after the '=' so it's not incorrect for the candidate list to pop up. You could also disable the auto-pop up which would help in this case.
    4. I would like an option to use CTRL+J to get the candidate list so it's consistant with VS .Net.

    I've added it to our list.

    Thanks for the feedback,

    Tilman
    Tilman
    0
  • Johannes
    Can you perhaps add another option to the Candidate list to only pop up when an alpha letter got pressed on the keyboard, to also be more consistant with VS. Or perhaps have a combination of the candidate options available.
    Johannes
    0
  • Tilman
    Can you perhaps add another option to the Candidate list to only pop up when an alpha letter got pressed on the keyboard, to also be more consistant with VS.

    I've added it to the list.
    Or perhaps have a combination of the candidate options available.

    Not totally sure what you mean. Could you expand a bit on that?

    Regards,

    Tilman
    Tilman
    0
  • Johannes
    Don't worry about my second suggestion. I was thinking to have the ability to combine 2 options like Manually activating list and to activate when alpha letter is pressed... But that would automatically be possible since the Manual option is always available... So please ignore previous comment.
    Thanks
    Jo
    Johannes
    0

Add comment

Please sign in to leave a comment.