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

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

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
Go

SELECT * FROM Sales.Currency

and hit F5 it works fine.

I go, let's say, 2 lines below the above statement & type in
Se
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?

Thanks!
Cowski
0

Comments

1 comment

Sort by
  • Chris Auckland
    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.
    Chris Auckland
    0

Add comment

Please sign in to leave a comment.