Comments
Sort by recent activity
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.
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...
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.
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.