SP suggestion

• 
  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.

  Anu D August 21, 2009 04:01

  - 0 +
• 
  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

  aGoram August 21, 2009 08:51

  - 0 +
• 
  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.

  Anu D August 21, 2009 09:24

  - 0 +
• 
  Thanks a lot.

  aGoram August 21, 2009 09:27

  - 0 +
• 
  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...

  aGoram August 21, 2009 11:29

  - 0 +
• 
  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

  michaelfried August 21, 2009 15:13

  - 0 +

Add comment

Please sign in to leave a comment.