Adobe LiveCycle ES4 add new and update Access Database, Non-Null failure

[#1]

I am using adobe livecycle es4 and I am trying to add a new record and then update it to an Access database. However, when i press update the error tells me that i cannot have Null values and it displays a check box field name. How can i allow a null value for a check box? Because when my form is used, not all of the check boxes will be checked

[#2]

I would like to know how to allow a check box to accept a NULL value (unchecked)?

[yvindevogel]

check the ResetData() function

[#4]

Where would I find that?

[#5]

I am getting the error: "Non-nullable column cannot be updated to Null" for my check boxes when I click the "Update" button on my pdf form

[Ajay_Yada]

Make the checkbox state to On/Off/Neutral and try.

Not sure if this works but i think worth a try.

[yvindevogel]

It's a function, look it up in the help file how you can use it on your checkboxes

[#8]

Tried it, no go. Thank you though. Keep thinking

[#9]

Could not find it in help, found resetData() in the xml code but it was for the reset button

[#10]

It allows me to update the first time perfectly for the database, but it will not update any "addNew"s I try after the first one.

[ADEL_CAP]

You can use the resolveNode function that can catch the null value of your check box component.

Exemple:

if (this.resolveNode("NameCheckBox").rawValue == null)

{

//Do Something

}