Comments
1 comment
-
Hi Terry,
Thanks for reporting this, and apologies for the difficulties it's been causing you. We are very aware that SQL Prompt can behave quite inconsistently in terms of the completion assistance it provides sometimes, which is mainly due to the fairly simplistic parsing model in the current version. SQL Prompt 3 will include a completely rewritten parser model and so should behave much more consistently. We're also working towards making it much more Visual Studio-like in terms of its completion behaviour, so when you'd expect it to complete for you in VS then SQL Prompt should also do so.
All being well SQL Prompt 3 should be available sometime in September, and we're planning to run a beta program sometime in July or August so if you'd like to be part of that please feel free to drop me an email at bartDOTreadATredHYPHENgateDOTcom.
Many thanks,
Add comment
Please sign in to leave a comment.
I get mixed results when use SQL Prompt (SP) and don't know if it is something I can change or what. It seems like *most* of the time SP requires me to fully qualify everything...
SELECT [Database].dbo..[Field] FROM [Database].dbo.
I have to do this whether I chose [Database] in the 'database dropdown' or issue/execute a USE [Database] or not. But sometimes it seems as though SP will 'know' what database I'm on and let me just type
SELECT .[Field] FROM WHERE .[Field2] = 1
I seem to be allowed the later syntax (more preferrable) more often if I make sure to have at least one blank line between query statements in QA. However, even with this syntax I don't like having to type in front of Fields especially in the WHERE clause.
Is there a FAQ somewhere on the limitations or guidance on how to make SP work 'better'. I like the tool and the concept is obviously fantastic but it lacks just a little bit. I'd like to be able to type...
SELECT [Field] FROM WHERE [Field2] = 1 and get intellisense for all the [ ] items in the previous statement. Maybe it's not possible.
One final 'minor' request, when the intellisense pops up, you can hit TAB, ENTER, or '.' to autocomplete. It'd be nice if SPACE autocompleted too to be consistent with VS IMHO.