allow NULL as input for Stored Procedure parameter

Alan Jiang shared this idea ago

Idea Logged

Hi Support,

NULL param is unable to pass in to a proc. Hope in next version it can do so. Stmt like this is more often:

WHERE (kClass = @kClass or @kClass is null)

Cheers,

Alan

I like this idea 0

Comments (3)

Guest ● 19 months ago

Hi Alan,

I see what you mean! I have tried this out and I agree with you that a NULL value can't be passed into the stored procedure view.

I have raised an enhancement request based on this Idea and will let you know whether it gets accepted by the product team when they get around to reviewing it.

regards,

David

Reply URL

Zack Wilson ● 2 months ago

Is there any updates on this?

Reply URL

Lesley Goggin ● 2 months ago

Hey Zack,

I have checked the internal development task on this and, unfortunately, there hasn't really been any movement on it. However, I have now added your company name as a client that would also like this and made a note to the devs asking if this has any plans for future releases. I will let you know once I have a response on this - I hope that is ok :)

Best Wishes,

Lesley

Reply URL