Comments
Sort by recent activity
I do not have that option selected, and I wouldn't want it selected because it would include invalid selections.
I turned it on, and when it was one the columns were suggested.
What I noticed is with the option turned off when I just have "backu" typed it properly lists the columns, when I add the "p" the columns go away, but then if I type a "_" the columns come back. Maybe it has to do with "backup" being a reserved word or something? / comments
I do not have that option selected, and I wouldn't want it selected because it would include invalid selections.
I turned it on, and when it was one the columns were suggested.
What I noticed is wi...
Is this something that will be fixed in a future version? (I wouldn't think field names that start with a reserved word should cause a problem.) / comments
Is this something that will be fixed in a future version? (I wouldn't think field names that start with a reserved word should cause a problem.)
I see this wasn't fixed in 4.0.3... I, also, noticed you didn't mention a assigned tracking ID. Are you not going to fix this? / comments
I see this wasn't fixed in 4.0.3... I, also, noticed you didn't mention a assigned tracking ID. Are you not going to fix this?
It does, however the suggestion isn't the problem, it is the lack of it capitalizing the reserved word when it is supposed to.
Try this:
SELECT *
FROM msdb.dbo.backupfile
WHERE
CASE
CREATE TABLE dbo.[Case]
(
Test varchar(10) null
);
--Refresh Suggestions
SELECT *
FROM msdb.dbo.backupfile
WHERE
case<cursor>
DROP TABLE dbo.[Case];
If you try it before you create the [Case] table and refresh the suggestions CASE is properly capitalized after you type it and a space, once you create the [Case] table it is not. / comments
It does, however the suggestion isn't the problem, it is the lack of it capitalizing the reserved word when it is supposed to.
Try this:
SELECT *
FROM msdb.dbo.backupfile
WHERE
CASE
CREATE TABL...
It appears from what I have heard that Red Gate doesn't think this issue impacts many people, and it isn't slated to be fixed in version 5 that they are working on now. If you experience this bug and would like to see it fixed speak up now so that maybe they will add it to their list to fix. / comments
It appears from what I have heard that Red Gate doesn't think this issue impacts many people, and it isn't slated to be fixed in version 5 that they are working on now. If you experience this bug a...
I'll just add my 5 cents, if you change it please make it an option, as we need it to stay working just like it is. / comments
I'll just add my 5 cents, if you change it please make it an option, as we need it to stay working just like it is.
As a note for people, if you get their instructions and follow them you can increase how much of your batch gets processed, but it is still slower than 3.x looking at the entire batch. / comments
As a note for people, if you get their instructions and follow them you can increase how much of your batch gets processed, but it is still slower than 3.x looking at the entire batch.
Is there any progress on this issue? I just installed 4.0.3 and it actually made it worse. Now it appears that SQL Prompt is looking at even fewer characters/lines for suggestions.
Any chance of getting the "Evaluate the whole batch" option back like 3.x had? I don't care if it is a little slower, slower is better than useless. / comments
Is there any progress on this issue? I just installed 4.0.3 and it actually made it worse. Now it appears that SQL Prompt is looking at even fewer characters/lines for suggestions.
Any chance of ge...
Great, thanks!
Is there anyway we can use that number to check the status or would we just need to ask you? / comments
Great, thanks!
Is there anyway we can use that number to check the status or would we just need to ask you?
Oliwa,
What version of SQL Prompt are you using? I suspect your problem may have been fixed in the 4.0.2.53 update. My issue with the case not being updated after hitting enter was. (Here is a link to my post: http://www.red-gate.com/MessageBoard/vi ... php?t=9461)
Anu,
I have seen this happen as well even with the new version, but I can't reproduce it on demand. / comments
Oliwa,
What version of SQL Prompt are you using? I suspect your problem may have been fixed in the 4.0.2.53 update. My issue with the case not being updated after hitting enter was. (Here is a link...