Re: Field won't default to 0

Shiva — Fri, 06 Mar 2009 02:16:46 GMT

Hello,

Can you check once your rule is setting to that field value or not any other? You have to run this rule after executing the data base retrieve query otherwise again that set back from ‘0' to null.

Field won't default to 0

clawrence — Thu, 05 Mar 2009 20:01:40 GMT

I'm working on a form that is connected to a SQL database. The field I'm working with is not a required, and can accept null.

When I pull the record information into my form, I then want to set this field to 0.00. I've tried setting the control in InfoPath to 0, and that didn't work. I've also tried setting a rule so that when the form is opened, it sets the field to zero. That's not working, either. Upon submit, the field remains null.

Does anybody know another way to do this?

SQL Database Integration

Re: Field won't default to 0

Field won't default to 0