Feature Request: ALTER Object behaviour
TOftring
Posts: 10
Hello,
we bought SQL Prompt for our company. It`s a very cool tool ;-). But we have one suggestion.
The feature to edit a procedure or a function by autocompletion with the tab key is genious but has one little mistake:
ALTER PROCEDURE --> Tab is a great thing but would it be possible that SQL Prompt checks if there is a newer version of the procedure in the SQL Server than in the SQL Prompt cache. In the moment it is necessary to change the database or to refresh the cache before editing the procedure.
The same thing for functions.
Cu
Toftring
we bought SQL Prompt for our company. It`s a very cool tool ;-). But we have one suggestion.
The feature to edit a procedure or a function by autocompletion with the tab key is genious but has one little mistake:
ALTER PROCEDURE --> Tab is a great thing but would it be possible that SQL Prompt checks if there is a newer version of the procedure in the SQL Server than in the SQL Prompt cache. In the moment it is necessary to change the database or to refresh the cache before editing the procedure.
The same thing for functions.
Cu
Toftring
Comments
Thanks for posting. It's something we'll consider for the future. The new version of SQL Prompt (3.5) has a shortcut for refreshing the cache without needing to open the Cache Management dialog. I'll be announcing the availability of the 3.5 release candidate within the next 24 hours so you might want to give that a whirl.
Thanks,
Bart
Principal Consultant
bartread.com Ltd