Posts
Sort by recent activity
when is 3.1 coming?
This release still includes bugs that I and others have brought up previously:
The candidate list interferes with typing table aliases and SQL keywords ("where", "order by", "group by", etc)
No fo...
long column names in the candidate list are truncated
The candidate list truncates column names longer than 15 characters down to 13 characters. Compare this to the behavior of Visual Studio, which happily displays the full text of such long class na...
error when opening two Query Analyzer windows
When I open two Query Analyzer windows in rapid succession, the first window opens correctly and starts loading, but when the second window opens, I get an error:
Unhandled exception has occurred ...
update query with table alias confuses SQL Prompt
If I try to type an update statement that uses a table alias, SQL Prompt behaves quite badly. For instance, if I type this query to look at the rows that I want to modify:
select *
from Foo f
join...
Candidate list captures Home and End
When the candidate list is displayed, SQL Prompt captures the Home and End keys, using them to move to the top and bottom of the candidate list, respectively. Visual Studio's Intellisense does not...
various quirks
I've been playing around with various things that didn't work as I expected in SQL Prompt 2 to see what has changed in 3. The new version is definitely a step up, and would be close to perfect, wi...
extraneous foreign key relationships shown after join .. on
When typing a query that involves several tables, the popup after typing "on " contains all of the relationships between the tables used so far in the query, rather than just the relationships betw...
no popup after "from" anymore
I have been using SQL Prompt daily for a few weeks now, but last week, I stopped getting a popup after typing "from ".
It used to be that typing "from" and then SPACE would cause the popup window t...
table names should not be case sensitive for FK completion
SQL Prompt does not autocomplete foreign key relationships in a SQL fragment if the tables are not typed with exactly the same case. SQL Prompt should be case-insensitive unless the database's col...
compound keys are not handled
Compound foreign key relationships are not handled properly. Instead of offering to join the two tables on all of the key fields, SQL Prompt offers to join each of the key fields individually.
For...