Works...then doesn't work...
Cowski
Posts: 23 New member
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!
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!
Comments
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.