How can we help you today? How can we help you today?

Candidate list does not auto show for database objects

I just installed the final beta patch refresh (3.0.0.819) and gave it a very simple test.

I noticed in the release notes for this final version that you note:
"The SQL Prompt 'popup' is too aggressive and pops up a lot" (http://www.red-gate.com/MessageBoard/viewtopic.php?t=4031)

Well, I certainly got a big surprise when I did a small test. I have set these SQL Prompt Options:
Availability > Candidate List > Automatic, 1 millisecond.

Now, I am wanting to type the following SQL: 
SELECT * FROM [Fund]

So, I start typing:

On typing the the S of SELECT, I get an auto complete list. GOOD.

On the F of FROM, I get another auto complete list. GOOD.

I hit space after the FROM keyword is entered and wait...and wait for the most valuable completion list that is going to tell me the object names. It does not appear. I had to press Ctrl+Space to show the list. NOT GOOD.

Now, the first two auto completions are useful, although even I, a humble C# programmer, know enough SQL to get a SELECT clause going. For me, the most important completion list has always been the list of objects. That feature is what compelled me to buy the pre RedGate version of this product and it remains, to me at least, the killer feature of this product.

I sure hope that the non-automatic popping up of database objects is an oversight and that it gets included in the final release. At the very, very least, please, please include an option to automatically show the list for database objects.
hebbja
0

Comments

3 comments

Sort by
  • Bart Read
    Hi there,


    We've actually modified the popup behaviour further to bring it up after certain keywords, of which FROM is one. Generally it doesn't pop up automatically after whitespace, however you can configure words that will trigger the popup once some whitespace has been added after them. We haven't exposed this through the UI due to lack of time, however you'll be able to modify the configuration to add/remove words that trigger the popup.

    Hope that helps.


    Thanks,
    Bart
    Bart Read
    0
  • hebbja
    We've actually modified the popup behaviour further to bring it up after certain keywords, of which FROM is one

    Can I take it that this change you refer to is implemented in a later version than the final beta patch refresh (3.0.0.819)?

    The list did not come up atomatically for me when pressing the spacebar immediately after the FROM keyword.
    hebbja
    0
  • Bart Read
    Hi there,


    That's correct: I said it will be available in the final release. We're still testing at the moment but hope to announce this early next week.


    Thanks,
    Bart
    Bart Read
    0

Add comment

Please sign in to leave a comment.