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

SQL Prompt Column picker not available

After the latest update to SQL Prompt (10.13.11.1536), the "column picker" does not appear active.  How can we reactivate it?
Nozme
0

Comments

3 comments

Sort by
  • Robyn
    Hi, 

    Is the column picker greyed out or not appearing at all. Please could I also ask for an example of how you are trying to use it? 

    The Column Picker is only available when it is valid syntax to insert more than one column into your code at this point in the query, and there are columns available to insert. For example, the column picker is available for SELECT statements and after ORDER BY, but not in a WHERE clause.
    Robyn
    0
  • Thomas_C
    Another thread that has been started may alsobe applicable here -- the SQLPrompt "intellisense" seems broke in 10.13.11.1536 version which would (and does) prevent the column viewer from popping up because it has no columns to show because it is not recognizing ANY db objects while writing SQL in SSMS 18.x.  We have several SSMS 18.x versions running around here and all that have updated to lastest SQLPrompt are impacted and we aren't all on the same version of SSMS 18.x.
    Thomas_C
    0
  • Tom_C
    Hi @Thomas_C

    Sorry you've seen this issue with SQL Prompt, can you advise what version of SQL Prompt and SSMS you are currently using if you believe the issue still persists?

    Additionally, you mention another thread in your last post here, can you provide a link to this if this is another forum post as I'm unable to locate it.
    Tom_C
    0

Add comment

Please sign in to leave a comment.