Comments
Sort by recent activity
A complete uninstall/reinstall seems to have solved this problem. / comments
A complete uninstall/reinstall seems to have solved this problem.
Also having this issue, and it's quite annoying. I often have to re-trigger the auto-suggest manually and pick, because it never works properly the first time when it's triggered automatically - it'll highlight the first suggestion for a fraction of a second, but then it removes it. / comments
Also having this issue, and it's quite annoying. I often have to re-trigger the auto-suggest manually and pick, because it never works properly the first time when it's triggered automatically - it...
Feature requests and improvements to functionality are not something RedGate seems to be very good at. / comments
Feature requests and improvements to functionality are not something RedGate seems to be very good at.
Repair went quicker than expected... 5.1.94.2 shows the same behaviour. / comments
Repair went quicker than expected... 5.1.94.2 shows the same behaviour.
Eddie,
I think you have misunderstood my problem. I'm editing an existing statement, not typing it anew and expecting SQL Prompt to magically determine what table I'm referencing - although that would be kind of cool, and maybe a cup of coffee to boot? [image]
So anyways, here's the scenario again: SELECT ColumnOne ,
ColumnTwo ,
ColumnThree ,
--1
CASE WHEN TT.ColumnFour = 1 THEN 'One'
ELSE 'Dunno'
END AS ColumnFourText ,
--2
ColumnFour ,
ColumnFive ,
ColumnSix ,
ColumnSeven ,
ColumnEight ,
ColumnNine ,
ColumnTen
FROM dbo.TableTest TT
If I start *editing* this statement, and typing directly on the line where the --1 comment is, I can see the TT alias in the suggestions, but none of the columns, and upon selecting the TT alias I get no suggestions for columns there either. If I do this same thing where the --2 comment is, I get suggestions just fine, and I also specifically see the column names in the suggestion list without typing the alias as well. I also get suggestions at --1 if I first put a comma on the line, and then put the cursor in front of it and start typing.
My version of SQL Prompt is 5.1.8.2.
I can't try the latest and greatest version at the moment, as after I installed it SQL Prompt would no longer start on my testing machine any more (says it requires a repair of SSMS and VS, oh joy!). / comments
Eddie,
I think you have misunderstood my problem. I'm editing an existing statement, not typing it anew and expecting SQL Prompt to magically determine what table I'm referencing - although that wo...
eddie davis wrote:
Thank you for your forum post.
Can you please confirm if you have enable this option enabled?
Open SSMS ->SQL Prompt 5 menu ->Options -> Under suggestions -> Types of suggestion -> Enable the check box "List all database columns after a SELECT statement".
Hopefully having the above option enabled will resolve this problem.
Many Thanks
Eddie
That does appear to bring in the columns, however it appears to bring in every other database column as well - and I think that may be worse for scenarios where the suggestions were already working.
I have noticed that when I add a comma first on that line, hit home and start typing before it that the suggestions are now working properly again (without the List all database columns after a SELECT statement' option checked). This may work for the time being, but it would be nice if I didn't have to do that. / comments
eddie davis wrote:
Thank you for your forum post.
Can you please confirm if you have enable this option enabled?
Open SSMS ->SQL Prompt 5 menu ->Options -> Under suggestions -> Types of suggesti...
I'd also like the ability to set the shortcut keys. CTRL-B-L is ingrained in my brain at this point, and it's going to take a good long time to re-train myself. / comments
I'd also like the ability to set the shortcut keys. CTRL-B-L is ingrained in my brain at this point, and it's going to take a good long time to re-train myself.
This is something that I would definitely be interested in as well, as are the other four users (of SQL Prompt) here at my org. / comments
This is something that I would definitely be interested in as well, as are the other four users (of SQL Prompt) here at my org.