What are the challenges you face when working across database platforms? Take the survey

Intellisense when calling a function inside a function

PowlinPowlin Posts: 42 Bronze 3
edited October 8, 2009 9:45AM in SQL Prompt Previous Versions
I'm unable to get the definition of a function when putting my cursor on the function name when used has another function parameter

Here is my 2 functions definition

CREATE FUNCTION [getClassified](@Path varchar(260), @FullPath varchar(260), @Call_ID int)
RETURNS varchar(260)

FUNCTION [getValidAttachment](@Call_ID int, @NetworkPath varchar(260), @Path varchar(260))
RETURNS varchar(260)

If I write something like this

DECLARE @Path varchar(260)
SET @Path = dbo.getClassified(@NetworkPath, dbo.getValidAttachment(@Call_ID, @NetworkPath, @NetworkPath), @Call_ID)

so the result of getValidAttachment is a parameter of getClassified and If I try to get the definition of getValidAttachment it's not possible because he show the getClassified parameters and not the getValidAttachment definition.



  • Options
    Anu DAnu D Posts: 876 Silver 3
    Thanks for your post.

    I have logged this issue (SP-2841) in our internal tracking system.

    So that this can be considered as a release candidate in future.

    Kindly let us know if you have any issues or questions regarding the product,I'll like to help.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.