Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

Avatar

Level 2

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

0 Replies

Avatar

Level 2

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

Avatar

Level 2

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

Avatar

Level 3

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

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

Avatar

Level 2

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

Avatar

Level 2

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

Avatar

Level 2

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

Avatar

Level 2

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.

Avatar

Level 1

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

}