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

Column Picker grey out

I must be missing something, an option, etc.: there are numerous occasions when the my Column Picker is greyed out when it is most logically the time to be used.
For instance, if I type: "Select dbo.MyTable.", the suggestion box appears with the list of columns, but the Column Picker is disabled.

If I pick a column and add the "From dbo.MyTable" clause, then go back to finish picking columns, it is available. This is nuts. Anytime there are tables "TableName.", this should be available.

Thanks.
sunibla
0

Comments

4 comments

Sort by
  • James R
    Hi sunibla,

    Thanks for your feedback!
    I agree, the current functionality disabling the column picker after qualifying the table name doesn't make much sense.

    I've logged this as an issue and will let you know when it's been fixed.

    Thanks,
    James
    James R
    0
  • rbriceno
    Hi,

    We just installed SQL Prompt version 8.0.8.2086 and are experiencing the same issue of Column Picker grey out. We can see all the columns in the column list but can not cherry pick them since we cannot access the picker. Any updates on this issue?
    rbriceno
    0
  • rbriceno
    After writing the SELECT statement again with "*" first, and then deleting the "*" with backspace, then SPACE bar, the column picker was available. Not sure why it did not work before but it is working now. Thanks!
    rbriceno
    0
  • ipisors
    This is ridiculous.  How many sql developers don't use table aliases in their queries?  Zero?  Then who benefits from the SQL prompt's intellisense?  Also zero?  Surely I am missing something for a $1500 product, this is close to unbelievable.
    ipisors
    0

Add comment

Please sign in to leave a comment.