Select to view content in your preferred language

Attribute Rule Calculation and field_is_nullable parameter

346
1
03-19-2024 06:19 AM
TylerT
by
Frequent Contributor

Hello,

When setting up fields with an attribute rule calculation, what should the field_is_nullable parameter be set to (NULLABLE, or NON-NULLABLE)?  I will test this, but wanted to get any background on this in any case, because I have a child table that fails to create records under this condition and as NON-NULLABLE.  Thank you.

Tyler

ArcGIS Pro 3.2.0

0 Kudos
1 Reply
torearth
Emerging Contributor

NULLABLE: If the field is nullable, it means that the field can accept null values. This implies that the field doesn't necessarily need to have a value in every record.

NON-NULLABLE: If the parameter is set to non-nullable, it means that the field cannot contain null values. Every record must have a value assigned to this field.

In your case, if you're setting up an attribute rule calculation and your child table fails to create records under the condition of the field being non-nullable, it suggests that the attribute rule calculation might be attempting to insert a null value into a field that doesn't allow it.

0 Kudos