No Hints for Variable

JohnHWk · August 25, 2009 4:32PM

I key the following SQL:

DECLARE
	@StartDate	datetime,
	@EndDate	datetime,
	@RepID		varchar(25)

SELECT
	@StartDate = '2009-01-01',
	@EndDate = '2009-03-31 23:59:59',
	@

I get no suggestions at all (I should get a suggestions to complete @ RepID). This worked fine in 3.9x, but not now. Any help much appreciated.

Regards,

John Hopkins

Anu D · August 27, 2009 4:51AM

Many thanks for your post.

We have logged your issue and will have it addressed in our future releases. Reference number for the issue is SP-2789.

Sorry for the inconvenience caused by this issue.

tanya · September 2, 2009 7:44AM

Hello,

This issue is now fixed with the latest update build.

For more details, kindly visit the following post:)
http://www.red-gate.com/MessageBoard/viewtopic.php?t=9517

Regards,
Tanya
Project Manager
Red Gate Software Ltd

nhustak · September 9, 2009 8:21PM

First off, please put the release numbers in the posts about new versions.

Second - version 4.0.2.53 - it is still erratically picking up declared variables.

ALTER proc &#91;dbo&#93;.&#91;Matcher_PostBuildingKeyAndScore&#93;
	@Matcher_Output_pk INT = null,
	@Building_fk INT = NULL,
	@BuildingMatchScore INT = NULL,
	@BuildingPass VARCHAR&#40;5&#41;
as

set nocount on;			

if @Matcher_Output_pk is not null

	UPDATE
		dbo.Matcher_Output 
		SET
			Building_fk = @Building_fk,
			BuildingMatchScore = @BuildingMatchScore,
			BuildingPass = @BuildingPass
	WHERE 
		Matcher_Output_pk = @Matcher_Output_pk

@BuildingPass did not pick up when I typed it.

I hit refresh cache and suddenly it picked it up. I duplicated this in another window and nothing makes it work.

Here's the other proc - I have refreshed the cache, backed up and retyped the @ several times. Nothing.

ALTER proc &#91;dbo&#93;.&#91;Matcher_PostBusinessKeyAndScore&#93;

@Matcher_Output_pk int = null,
@Business_fk INT = NULL,
@BusinessMatchScore INT = NULL,
@BusinessPass VARCHAR&#40;5&#41;
as

set nocount on;			

if @Matcher_Output_pk is not null


	UPDATE
		dbo.Matcher_Output 
		SET
			Business_fk = @Business_fk,
			BusinessMatchScore = @BusinessMatchScore,
			BusinessPass = @
	WHERE 
		Matcher_Output_pk = @Matcher_Output_pk
		
return&#40;@@rowcount&#41;

Is it possible to get the install for version 3.x? I really feel llike 4.x was released too early - some of the core functionality isn't working correctly. I like where it's headed, but I'd rather wait until the bugs are ironed out.

wsoranno · September 14, 2009 10:59AM

I am having the same problem.
It does not matter if I am in SSMS 2008 or VS 2008.

I will be going back to ver 3.9 until the version after 4.0.2.53 comes out.

tanya · September 15, 2009 6:14AM

Hello,

@nhustak - Thank you for giving us the code. We tried to replicate the issue and having troubles in doing the same in our environment with similar or same code. If you are able to consistently replicate the issue it would be of help if you can let us know the following:
â€¢ On manually invoking the suggestions list using CTRL+SPACE after typing @ can you let us know what are the top 5 objects you see?
â€¢ After manually typing in @BuildingPass, does hovering over the object display the object tooltip that reads @BuildingPass (Parameter) if you have not unchecked object definitions in the options menu?
Sorry about the missing build no in the forum post.

@wsoranno - Do you have any sample code wherein you are able to consistently replicate the issue?

Sincere apologies for the trouble caused due to this issue.

Thanks,
Tanya
Project Manager
Red Gate Software Ltd

nhustak · September 15, 2009 9:33AM

I have gone back into the procs and reset them. Unfortunately (?), it works though I do have to manually invoke.

For what it's worth, I do always hit manual invoke when nothing pops up and that usually works (I also am very quick to rebuild the cache via hotkey). If I'm having problems, it will show a list of internal function calls. From my memory, what is intersting is it shows none of the variables. I say that because the first time it happened, I immediately went into the options to change the 'look behind' distance to all - except that option has been removed in 4.0. I assume it's look at all code now always.

The next time this happens, I will be sure to manually invoke per your request and gather information.

Regards,
Nick

TSchwab · September 15, 2009 10:15AM

@RowCount etc., only. Even after CTRL-SHIFT-D.

SQL-Prompt 3.9 does not have this problem.

wsoranno · September 15, 2009 10:23AM

Tanya
I sent you an email with a script attached.
I experienced the error starting on line 482.
That is where I was making an update to the script.

Dave Pendleton · September 16, 2009 10:02AM

Unfortunately, with the new release I am still seeing this behavior.

TSchwab · September 21, 2009 8:58AM

Any new info about this problem? :?:

nhustak · October 4, 2009 10:50AM

Ok guys, this product cost far too much for the basics to still be non-functioning. The level of frustration I am dealing with EVERYDAY is starting to get to me.

Please post the latest 3.x version for download - I need a version that works. (NOLOCK) pretty much rendering it inoperative is making sql prompt useless for me. 90% of our stored procesdures use nolock. This is a serious problem for me. I am very dependent on SQL Prompt - I'm a contractor and I regularly work with large databases with what amounts to random fieldnames. So EVERYDAY I get more and more angry as SQL Prompt fails to work. This isn't something I use once a week - it's something I use all day long.

I apologize for the tone of this post but I really feel like I am beta testing an application at this point and I didn't sign up for that. I want to revert to 3.x until this thing is working.

As it stands, I feel like we all deserve an extension on our support. For me, it's nearly unusable with the current bugs. If it weren't part of the package I purchased, I'd be returning it for a refund. THAT is how frustrated I am at this point.

This post is a product of the last two days of SQL Prompt 4 constantly failing due to the fact I am debugging stored procedures that contain NOLOCK. 4 is certainly faster than 3 - but that speed doesn't help when it constantly fails to function.

Regards,
Nick Hustak

tanya · October 4, 2009 5:37PM

Hi Nick,

We totally understand and my sincere apologies for the trouble caused with the NOLOCK issue.
We are working on it and will have a public release out that includes the NOLOCK fix by end of this year. Meanwhile, I will send you the link for v3.9 installer.
Does that help?

Sorry for the inconvenience caused.

Thanks,
Tanya
Project Manager
Red Gate Software Ltd

nhustak · October 4, 2009 8:44PM

Yes the v3.9 installer would help immensely.

Thank you,
Nick

David Atkinson · October 5, 2009 4:49AM

Previous versions of many Red Gate products can be found here:

http://www.red-gate.com/supportcenter/G ... rsions.htm

Kind regards,

David Atkinson
Red Gate Software

nhustak · October 5, 2009 3:45PM

Thanks David - I had no idea that was there.

PDinCA · October 20, 2009 8:16PM

Post removed - dumb user error!

Anu D · October 28, 2009 12:32PM

Thanks for your post.

Can you please remove the last 'GO' command and check if SQL Prompt suggests the variable?

PDinCA · October 28, 2009 12:45PM

Well, when one forgets that GO puts the variable out of scope one must expect it to be missing from the suggestions - DUH!

Apologies... Note to self, "GO is a pain to remember!" :oops:

MikeyC · December 11, 2009 12:09PM

I don't think this issue has ever gotten fully identified, here is a sample that I think will help:

DECLARE 
@Name VARCHAR&#40;1000&#41;,
@PageCount VARCHAR&#40;1000&#41;;

SELECT 
	@PageCount = backed_up_page_count&lt;CURSOR&gt;
FROM msdb.dbo.backupfile;

SELECT&lt;cursor2&gt;

If you select <CURSOR> and type a comma and hit ENTER and then @ you will get no suggestions unless you hit ctrl-space.

However if you instead type a B you will get suggestions for field name automatically.

At cursor2 if you type a space you get no suggestions, but you should get the two variables suggested.

Stuart Naftel · December 29, 2009 1:27PM

I am still having this problem (with version 4.0.3.11). It really is annoying, and hurts the usability of SQL Prompt.

I declare a bunch of variables. Then I declare a cursor, open the cursor, and do a fetch.

If I try to add variables to the Fetch ... "INTO @variable1", etc. I get no prompting at all showing me any of the declared variables, even with Ctrl-Space. If I add a statement like:

set @variable ...

before the FETCH statement, SQL Prompt will prompt me once I type the "@", but in the INTO clause of the fetch, or anywhere after it will not...

Stuart Naftel

No Hints for Variable

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk