What are the challenges you face when working across database platforms? Take the survey

Works...then doesn't work...

CowskiCowski Posts: 23 New member
edited December 22, 2009 2:50PM in SQL Prompt Previous Versions
I'm currently running the trial version of SQL Prompt 4 whilst waiting for the approval to come down from the powers that be to purchase a valid copy of it. So until then I'm putting it through it's paces.

The issue I'm running into currently is that if I put a statement in, say....

USE AdventureWorks

SELECT * FROM Sales.Currency

and hit F5 it works fine.

I go, let's say, 2 lines below the above statement & type in
one would think I should get "Select", "Set" or "Setuser", right?

Well I get nothing. No drop down, nothing. But yet if I go up, and delete out the "Select * ..." syntax & start there, I get the dropdown with suggestions again.

Is this the way SQL Prompt is supposed to work? One "F5" or one "Run" per window? Is there a setting I need to turn on/off?



  • Options
    Thanks for your post.

    I have reproduced this using the steps you outlined, and have logged a bug with the reference code SP-2890.

    It only seems to be the keyword 'Select' that isn't suggested, as after you finish typing Select manually, the suggestions start appearing again.

    You can also resolve this by adding a GO after the first select statement.

    Thanks for taking the time to report this.
Sign In or Register to comment.