Activity overview
Latest activity by mac300
SQL Prompt: Refresh Suggestions sometimes not working
Hi,The Refresh Suggestions process seems to not work all the time.Sometimes after I connect to a server and then to a DB, it will either automatically Refresh Suggestions and show them when I conti...
Aaron Law wrote:
I'm happy to hear you found the cause, and thanks for sharing the fix! [image]
Continuing to suggest the columns even if you don't strictly have permission sounds reasonable to me. Would you be able to send me steps to reproduce the behaviour you were seeing? (feel free to PM me if you'd rather not post them publicly)
Thanks,
Aaron.
Can post here - blurred some sections [image]
All I tried to do was select from a table, and use WHERE on specific Column that was not in Suggestion.
So, what our DBA did was add the Data Type permission to the Role my user is on - [image]
Let me know what other info you need [image] / comments
Aaron Law wrote:
I'm happy to hear you found the cause, and thanks for sharing the fix!
Continuing to suggest the columns even if you don't strictly have permission sounds reasonable to me. Wou...
Aaron Law wrote:
Hi mac300,
You might just need to refresh Prompt's suggestions if the column has been recently added to the table. Ctrl+Shift+D is the shortcut to refresh the current database, alternatively there's an auto refresh feature that's under the Experimental Features page of the options.
If this isn't the case then a screenshot and example script of where you're missing the columns would be really useful to help diagnose what's going wrong.
Thanks,
Aaron.
These are not new columns.
However, we found what the problem was. :idea:
Seems that the columns that were missing are using User Defined DataTypes.
So, although the previous App I used shows all these columns (SQL Complete), on SQL Prompt it seems to check the User permissions more thoroughly and blocks columns from showing in Suggestions.
Anyhow, the permissions was fixed for my user, so I can see them now.
But perhaps would be good by the app developers to check this? I mean, if a more simple app shows columns regardless of User Permissions for User Defined DataTypes, perhaps SQL Prompt can be updated to do the same. [image] / comments
Aaron Law wrote:
Hi mac300,
You might just need to refresh Prompt's suggestions if the column has been recently added to the table. Ctrl+Shift+D is the shortcut to refresh the current database, ...
Missing Columns in Suggestions
Hi,
I recently started working with SQL Prompt on MS SQL 2014 (Started with Trial and now Licensed, Ver 7.1.0.315), and love it
1 thing I noticed is that on some tables, the Suggestion frame is mi...