2. ASPRunnerPro General questions
  3. unselected dependency menus overwriting database defaults
This topic is locked

unselected dependency menus overwriting database defaults

 		4/15/2008 3:54:01 PM
ASPRunnerPro General questions
M
 mfred author

I am creating an ordering system. In the system, there are a series of items that they can select. When they select an item, the price loads. This all works fine. The problem is with the unselected. The price default in the database is zero for any unselected item. But ASPRunner blanks this out for any unselected items. I have the database calculate the totals, which it won't do if any price fields are blank. I need ASPRunner to not change fields that are not changed by a customer selection.
M
 		mfred author 4/18/2008

Any help on this is greatly appreciated.
J
 		Jane 4/22/2008

Hi,
you can do the following:

  1. check entered values in the Before record added/Before record updated event on the Events tab,
  2. if field value is empty change it to 0.
M
 		mfred author 4/22/2008

Thanks. However, I did not see an option for check entered values in the Before record added/Before record updated event on the Events tab. I checked both 5.1 and 4.0.
J
 		Jane 4/23/2008

Hi,
to check entered values add your custom code to the Before record added/Before record updated events.

Here is a sample:

if dict("FieldName")="" then

dict("FieldName") = 0

end if