Activity overview
Latest activity by Chris Palmer
I have found that even though I have a SELECT FROM <table> structure, example:
SELECT
FROM [dbo].[C21_TB_TimeRecord]
SQL Prompt displays all candidate fields from all tables, *unless* I make the next part of the SELECT specifically name the table:
SELECT [dbo].[C21_TB_TimeRecord].[tr_Case],
FROM [dbo].[C21_TB_TimeRecord]
Once this is done, then the candidate list is now restricted to fields from the required table, and once I figured out to turn off "Qualify non-aliased columns", I can get what I am trying to get - like this:
SELECT [dbo].[C21_TB_TimeRecord].[tr_Case], [TR_Case_CaseId]
FROM [dbo].[C21_TB_TimeRecord]
I can then go back and remove the the table name qualifier from the first candidate and SQL Prompt continues to work as required.
Is this "by design", is there some way to turn it off?
Thanks
Chris / comments
I have found that even though I have a SELECT FROM <table> structure, example:
SELECT
FROM [dbo].[C21_TB_TimeRecord]
SQL Prompt displays all candidate fields from all tables, *unless* I make the ne...
I've posted a reply on this over on the other thread headed by PDinCA, I found that the problem "went away" after I installed the latest Microsoft Update - that I found sitting ready to install when I got to work this morning - so it could be just differences in Windows installations that causes some people to get the problem. Note that I installed .NET 2 support just prior to installing SQL Prompt, so the update might have included a change in .NET 2. / comments
I've posted a reply on this over on the other thread headed by PDinCA, I found that the problem "went away" after I installed the latest Microsoft Update - that I found sitting ready to install whe...
More on this - I re-tried running SQL Prompt from the Program Menu today, this time it loaded a tray icon without complaint. The only difference between today and the previous day is a Windows Update that was installed. However, even though the tray icon is there, double-clicking it does not bring up the SQL Prompt manager, and right-clicking it only offers me an Exit.
Ctrl+spacebar did not initially activate SQL Prompt in Query Analyzer, but when I re-started Query Analyzer then SQL Prompt *did* load.
I don't think its "behaving" very well though, as it only works in one window (the first one loaded) of the Query Analyzer, and it "ignores" the table I am working on when offering me fields to Select. However I guess that should be the topic of another Post. / comments
More on this - I re-tried running SQL Prompt from the Program Menu today, this time it loaded a tray icon without complaint. The only difference between today and the previous day is a Windows Upda...
I am only running SQL 2000, I cannot run SQL Prompt 3 in the Query Analyzer - that is - Ctrl+Spacebar does not "turn on" SQL Prompt. / comments
I am only running SQL 2000, I cannot run SQL Prompt 3 in the Query Analyzer - that is - Ctrl+Spacebar does not "turn on" SQL Prompt.
I am getting the same problem, just to let you know it's not a "one-off"...
Is there anything that you would like to know about my PC settings that might help resolve this?
Chris / comments
I am getting the same problem, just to let you know it's not a "one-off"...
Is there anything that you would like to know about my PC settings that might help resolve this?
Chris
I to am getting this error upon trying to load SQL Prompt 3 beta. So if anyone comes up with a solution I would love to get notified. / comments
I to am getting this error upon trying to load SQL Prompt 3 beta. So if anyone comes up with a solution I would love to get notified.