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

Space bar to accept current selection

This may have already been brought up, but when naturally typing a command you would hit the space bar after an objet name. Currently SQLPrompt forces you to use the enter key to accept the current selection.

Is there a way to change this to space? for example

"Select col1 From Cl<space>" would fill out the statement "Select Col1 from Client "
chattabaugh
0

Comments

3 comments

Sort by
  • Tilman
    Hi,

    You can turn on Space completion on the Options tab of the Options dialog (accessible via the system tray icon).

    Regards,

    Tilman
    Tilman
    0
  • chattabaugh
    If you are taking about the option "Keys that will show a candidate list after a trigger word" this is not what I mean. I am talking about Selecting a word from the candidate list with a space instead of enter IE

    I type "Select<space>*<space>From<space>" and Candidate list comes up,
    I type "Cl" and candidate selects "Client" (One of many tables starting with "Cl")
    I type <Space> (or ".") and the candidate list closes and completes the word "Client<space>".

    This would be the natural order of typeing a statement... Select<space>*<space>From<space>Client<Space>
    ... Instead of the current SQLPrompt way... Select<space>*<space>From<space>Cl<Enter>(SQLPrompt adds "Client")
    chattabaugh
    0
  • Tilman
    Hi,

    Sorry, my mistake. I'm afraid SQL Prompt 2 can't do what you want. SQL Prompt 3 will work as described by you, however.

    Regards,

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.