Solved

Optional parameter in stored procedures

  • 13 January 2021
  • 2 replies
  • 56 views

Userlevel 3
Badge +11

As far as i can see, there is no option in the SF to define default values for subroutine parameters. When a default value could be defined they become an optional parameter in SQL server. 

Could this be an idea to add to the SF? The advantage is that you don’t have to define all parameters when calling a subroutine.

Or what should be the reason that this option is not available?

Or did I miss something and can it be done?

 

icon

Best answer by Jeroen van den Belt 13 January 2021, 11:35

View original

This topic has been closed for comments

2 replies

Userlevel 5
Badge +8

Hello Edwin,

We do not yet provide this as a formal option in our suite, but in my opinion this would be a very good idea. Please feel free to submit the idea in our ideation section. I think this idea can get a lot of votes.

Jeroen

Userlevel 3
Badge +11

Hello Jeroen. I have posted is as an idea:

Thanks for the reply. Question may be closed.