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

Problem in auto-completion when names contain spaces

If you have two tables in the same database that differs only for characters following a space, when you digit the name of the table at the space character SQL Prompt 3 completes the query (after a FROM, for example) with the name of the first table.
If you have a database (not defined by me, but I can't change those names) with tables named:
[Order Heading]
[Order Details]

You can't type [Order Details] with only the keyboard if SQL Prompt 3 is enabled.

Marco
marcorusso
0

Comments

3 comments

Sort by
  • Tilman
    Hi Marco,

    Thanks for pointing this out. You can currently get it to work by turning off Spacebar as a completion key (on the options dialog) and starting your identifiers with an open square bracket ('[').

    E.g.

    [Order H

    should now get you to 'Order Heading'.

    Alternatively, just type 'Order' and select other entries via the Up/Down Arrows.

    Regards,

    Tilman
    Tilman
    0
  • marcorusso
    Thank you for the suggestion.
    I think you stille should consider a more intuitive way to handle it because the lack of space as completion character could be a real miss (i.e. if the previous identifier begin/contain a [, then temporarily disable space as completion char).

    Marco
    marcorusso
    0
  • Tilman
    Thanks Marco, I've added your suggestion to the list.

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.