Oninit
Talk to an expert →

Informix Error -3430: This field requires an entered value.

Cause and resolution

This field requires an entered value.

The row cannot be added to the table until a value has been entered in the indicated field. A REQUIRED attribute in the form-specification file has been associated with the column. Enter a value in the field.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-3430 fires when a row is added without a value in a field marked REQUIRED — per the official guidance, a REQUIRED attribute in the form specification is associated with the column, and the row can't be added until a value is entered.

  1. A field marked REQUIRED in the form's ATTRIBUTES section was left empty, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Enter a value in the field, per the official guidance.
Examples
A REQUIRED field left empty
ATTRIBUTES
  cust_name = customer.name, REQUIRED;
-- -3430: adding a row with this field blank triggers the error
Diagnostic Checks
  1. Check the form specification for REQUIRED fields, and confirm all of them have values before adding a row.
Related Errors / Related Topics
  • -3101 — "The column column-name does not allow null values." A related required-value error, about the database's own NOT NULL constraint rather than the form's REQUIRED attribute.

A field marked REQUIRED in the form specification was left empty — enter a value.