Posts
Sort by recent activity
Query window in VS.Net
Am I missing something? SQLPrompt is working nicely in VS.Net for editing stored procs. However, it doesn't seem to know that Query windows exist at all. That is, when I open a query window either ...
Bad alias abbreviation
This is odd. Generally the aliasing of tables works fine. But it happens that the very first one I tried is the only one that I can make break consistently:SELECT * FROM Asset w
Where the heck di...
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 ...