Comments
2 comments
-
One other bug I forgot to mention:
Sometimes certain aliases won't trigger the intellisense box to appear. The workaround seems to be to use a different alias, trigger the intellisense, delete what you typed and use the original alias. You now get the intellisense.
Edit: Using the Edit function in phpBB updates the view count by 15! Nothing to do with you but quite amusing -
Hi there,
Thanks for posting, you've definitely spotted a couple of bugs there, for which I can only apologise. The parsing engine in the current version of SQL Prompt is pretty simplistic so it's quite easy to fool it by doing something it doesn't expect, hence the bizarre capitalisation behaviour etc.
As far as navigating through the list goes hitting the END key will take you straight to the last item, and conversely, hitting HOME will take you right to the top.
Hope that helps.
Kind regards,
Add comment
Please sign in to leave a comment.
- Highlighting and tabbing multiple lines in Microsoft SQL Server Management Studio's query window doesn't allow you to indent the selected text. Sql Prompt seems to have stolen your tab key altogether!
- Using a multi-line select statement doesn't trigger replacement of keywords with their uppercase equivalent, e.g.:
SELECT
*
from
from won't be replaced with "FROM".
Finally a suggestion, can the UP arrow jump to the bottom of the list, when the intellisense box is visible? So if you're at the top of the list, hitting the up arrow goes to the last entry.