Posts
Sort by recent activity
Won't work with QA
When I run the new beta with QA, the isqlw process starts and then immediately shuts down. A reboot did not help. If I disable "Start sQLPrompt when you start Query Analyzer", QA is able to run fin...
Beta 1 participants
If you've already purchased SQL Prompt 3 will be able to activate this version of the product with the license key(s) you’ve been sent.
Does this mean that those of us who participated in Bet...
No columns offered for WHERE clause
I could have sworn this worked before, but now it seems to fail universally. I can't get SQLPrompt to suggest any columns when I hit ctl-space after "WHERE ".
I've tried it with and without table a...
Illegal aliases
While trying to diagnose another problem, I turned on auto-aliasing. The very first one I got results in an alias that's a reserved word:
select * from ObjectField AS of
Feature request: parenthesis matching
I was just writing an expression with five levels of parentheses, and I was getting rather lost. Wouldn't it be nice if, when the cursor is on a parenthesis, its mate is highlighted? (Fans of Resha...
Datatypes in "Columns from all tables"
The "Columns from all tables" tab in the candidates list popup is drawn with two columns (Column Name and Container Name). However, there are (at least) three logical columns of information.
Specif...
Incorrect suggestions
I enter the following SQL (in QA):
select * from InventoryTransfer AS it
and hit ctl-space. I get a list of All common objects. Unfortunately, every one of these is a guaranteed syntax error.
I th...
Candidate selection problem
It's possible to resize the candidate window in such a way that a selection at the very bottom is impossible to read -- it's only visible as a thin blue bar.
Resize the window so that only the top ...
Missing feature/bug - USE autocompletion
If I ask for autocompletion after typing "USE ", I expect to get a list of databases (which seem to be in the "Other objects" tab). However, it pops up with the "All common objects" tab, most of wh...
General feedback
After just a bit of playing, here's some of my impressions (I'm currently a v2 user, and am using the tool in Query Agonizer)
I love the look of the new popup.
The window that shows the definition...