Activity overview
Latest activity by DaveTheWave
In QA SQLPrompt only works for the first window your open... / comments
In QA SQLPrompt only works for the first window your open...
I tried this again with a complete join clause and the problem presisted. / comments
I tried this again with a complete join clause and the problem presisted.
The list that I'm presented with includes columns and not just tables or views. / comments
The list that I'm presented with includes columns and not just tables or views.
If I add an ORDER BY or GROUP BY clause and invoke the canidate list and search for items that begin with 'F' as below:
select od.[ORDERID], od.[FINALPRODUCTID], od.[HEEL], o.[orderCategory],
od.[CustomerOrderDetailId]
from [dbo].[ORDERSDETAIL] od
join [dbo].[ORDERS] AS o
where F
order by od.[FINALPRODUCTID]
All canidates are filtered out of the list. / comments
If I add an ORDER BY or GROUP BY clause and invoke the canidate list and search for items that begin with 'F' as below:
select od.[ORDERID], od.[FINALPRODUCTID], od.[HEEL], o.[orderCategory],
od.[C...
Can not find a column from the where clause
When I type:
select od.[ORDERID], od.[FINALPRODUCTID], od.[HEEL], o.[orderCategory], od.[CustomerOrderDetailId]
from [dbo].[ORDERSDETAIL] od
join [dbo].[ORDERS] AS o
where F
I expect to be able to ...
I've noticed that SQL Prompt completly ignores the fact that I've already specified a table by typing 'o.' and then invoking canidate completion. / comments
I've noticed that SQL Prompt completly ignores the fact that I've already specified a table by typing 'o.' and then invoking canidate completion.
Using a previously assigned prefix
When I type:
select o.[ORDERID], o.[FINALPRODUCTID], o.[HEEL]
from [dbo].[ORDERSDETAIL] o
join ORDERS
I get:
select o.[ORDERID], o.[FINALPRODUCTID], o.[HEEL]
from [dbo].[ORDERSDETAIL] o
join [dbo]....
CTRL+SPACE after JOIN gives me column names
If I invoke the completion canidate list immediately after the JOIN keyword, I am presented with the "All common objects" list. I would rather be presented with the "Tables" list.
Query Analyzer
Prefix is duplicating
If I type:
select o.[ORDERID], o.[FINALPRODUCTID], o.HEEL
from [dbo].[ORDERSDETAIL] o
I get:
select o.[ORDERID], o.[FINALPRODUCTID], o.o.[HEEL]
from [dbo].[ORDERSDETAIL] o
Notice the duplicated pre...
Column spacing on completion canidate list
If I expand the completion canidate list, all columns expand by the same amount.
I think it would be nice to set the column widths individually. Or have a max width based on the longest table/colum...