No candidates in the list for FETCH NEXT ... INTO

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

No candidates in the list for FETCH NEXT ... INTO

Postby wsoranno » Wed Apr 27, 2011 8:26 pm

The candidate list only has snippets in it when you type the following and press ctrl+space:

FETCH NEXT FROM tmp INTO<space>

When you add the @ so the statement looks like this:

FETCH NEXT FROM tmp INTO @

The candidate list becomes empty.

This is with SQL Prompt 5.1.4.11 Pro.
Thanks
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 148
wsoranno@winona.edu

\"Quality, like Success, is a Journey, not a Destination\" - William Soranno '92
wsoranno
 
Posts: 43
Joined: Wed Oct 31, 2007 5:35 pm

Postby Anu Deshpande » Fri Apr 29, 2011 1:35 pm

Thanks for your post.

Can you please reply my email with the complete query which will help me to reproduce the issue?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby wsoranno » Thu Aug 08, 2013 11:24 pm

What is the status of SP-3928?
Thanks
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 148
wsoranno@winona.edu

\"Quality, like Success, is a Journey, not a Destination\" - William Soranno '92
wsoranno
 
Posts: 43
Joined: Wed Oct 31, 2007 5:35 pm

Postby Aaron Law » Fri Aug 09, 2013 1:21 pm

Hi Bill,
I’m sorry for the long delay in fixing this for you. I've just made a new build of our beta with a fix in which you can download from: http://download.red-gate.com/EAP/SQLPro ... Prompt.zip

Thanks,
Aaron.
Aaron Law
 
Posts: 250
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests