SP suggestion

aGoram · August 20, 2009 1:28PM

Im not able to have suggestion for stored procedure

exec sp_helptext <control+space> was working in v3

am i missing an option ?

Anu D · August 21, 2009 4:01AM

Thanks for your post.

Could you kindly check following settings:
1. SQL Prompt 4 --> Options --> Suggestions --> Type of suggestion --> Check List system Objects

2. SQL Prompt 4 --> Options --> Inserted Code --> Objects and Statements --> Check Insert parameters for functions and stored procedures.

Kindly let us know whether above settings resolves your issue.

aGoram · August 21, 2009 8:51AM

1 and 2 are check
and if i type exec <control+space> or alter procedure <control+space> it works.

But exec sp_helptext <control+space> doesn't work anymore in v4.
too bad, because it's very usefull to have a quick view on a SP

Anu D · August 21, 2009 9:24AM

I got your point thanks for explaining it to me.

I have added this issue in our internal tracking system and will be addressed in our future release. ID for this issue is SP-2777.

Sorry for the inconvenience caused by this issue.

aGoram · August 21, 2009 9:27AM

Thanks a lot.

aGoram · August 21, 2009 11:29AM

one other things

i can't have suggestion for SP on a new line alter i type ap_

for exemple :

select * from emp
ap_

but this work

select * from emp
go
ap_

it was fine on v3...

michaelfried · August 21, 2009 3:13PM

A Stored Procedure cannot begin a new line (or current line) after another statement (within a single batch) without using the EXEC keyword.

If you type in:

SELECT * FROM myTable
EXEC ap_

you should get all the suggestions that match your input.

Mike

SP suggestion

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk