Question Re: static database parameter should not be left empty in Technology Q&A

static database parameter should not be left empty

Former Member — Wed, 11 Jul 2018 16:27:50 GMT

I don't want the user to leave blank for static db parameter, a value must be entered. How we implement that in CR 2013. right now i am able to

Re: static database parameter should not be left empty

abhilash_kumar — Wed, 11 Jul 2018 17:16:00 GMT

Hi Neha,

Right-click the Parameter field > Edit > Scroll down and look for an option called "Min Length".

Type in "1" in the text box beside (without the double quotes).

-Abhilash

Re: static database parameter should not be left empty

DellSC — Wed, 11 Jul 2018 17:18:30 GMT

First, you need to make sure that the parameter definition is not set to "optional".

Do you have a static list of values you can use for the parameter? If so, then make sure "Allow Custom Values" is set to false in the prompt definition. This will force the user to select from the list.

If there is no list of values, then set the edit mask to "A########" with as many "#" characters as you need for the maximum length of the expected response. If the value the user needs to enter is a number, then you'll use "9" in the edit mask instead of "A". This will force the user to enter at least one non-space required character into the parameter.

-Dell

Re: static database parameter should not be left empty

Former Member — Wed, 11 Jul 2018 21:25:02 GMT

Thank you Abhilash - that was easy to implement.

Re: static database parameter should not be left empty

Former Member — Wed, 11 Jul 2018 21:31:56 GMT

Thank you Dell

I tried to implement the solution. It was for 2 number digits. So I entered "99". CR kept asking for 9. I am not i was implementing that correctly

Re: static database parameter should not be left empty

Former Member — Wed, 11 Jul 2018 21:32:50 GMT

it worked. Thanks Again

Re: static database parameter should not be left empty

DellSC — Thu, 12 Jul 2018 13:59:54 GMT

Did you include the quotes? If so, take them out because they mean that it will expect 9 instead of any number.

-Dell