Comments
1 comment
-
Hi Tele,
Thanks for reporting this. To be honest it's not that much of a nitpick. The current version of SQL Prompt is a bit fussy about what it will recognise and pop up intellisense for, however we're going to be fixing this in version 3 so watch this space. In the meantime I can only apologise for the hassle it's causing you.
Many thanks,
Add comment
Please sign in to leave a comment.
Capitalization does not work around parentheses, i.e.:
(select does not become (SELECT
count(*) does not become COUNT(*)
I saw one post that suggested adding spaces, i.e., ( select, and count (*), which does work. I would prefer not to have to change my formatting.
Another issue with parentheses is if I do this:
SELECT OrderID FROM Orders WHERE ( <stop here>
even though I added a space after the parentheses, Intellisense does not pop up. If I write the same query without the parentheses, Intellisense is there.
So in general, and in my opinion, I feel there should be an option to ignore parentheses in the capitalization and Intellisense behavior.
This is hands down one of the most useful tools I have seen and this is obviously a nitpick.
Thanks.