Oninit
Talk to an expert →

Informix Error -3420: This value is not among the valid possibilities.

Cause and resolution

This value is not among the valid possibilities.

A list or range of acceptable values has been established for this column (via an INCLUDE attribute in the form-specification file). You must enter a value within the acceptable range.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-3420 fires when an entered value falls outside a column's INCLUDE-defined list or range of acceptable values — per the official guidance, this list or range is established via an INCLUDE attribute in the form specification.

  1. The entered value isn't within the field's INCLUDE-defined list/range, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Enter a value within the acceptable range, per the official guidance.
Examples
An INCLUDE-restricted field
ATTRIBUTES
  status = order_status, INCLUDE = ("Pending", "Shipped", "Cancelled");

Entering "Delivered" into this field triggers -3420, since it isn't in the INCLUDE list.

Diagnostic Checks
  1. Check the field's INCLUDE attribute in the form specification, and enter a value that matches it.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -3420 in this set yet.

The entered value isn't within the field's INCLUDE-defined list or range — enter one that is.