Informix Error -1131

-1131 You cannot have multiple AFTER clauses for the same field.

This statement includes at least two AFTER FIELD clauses that name the same form field. Only one is supported. Find all the AFTER FIELD clauses that relate to one field, and combine them into a single clause.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-1131 is the mirror image of -1130: it fires when a statement includes two or more AFTER FIELD clauses naming the same form field — per the official guidance, only one AFTER FIELD clause per field is supported.

Two or more AFTER FIELD clauses in the same statement naming the same field, per the official guidance — the direct, only cause.

Solutions / Resolution

Consolidate all AFTER FIELD clauses that target the same field into a single combined clause, per the official guidance.

Examples

Duplicate AFTER FIELD clauses

INPUT BY NAME order_id, status
  AFTER FIELD status
    LET v_x = 1
  AFTER FIELD status
    LET v_y = 2
  END INPUT
-- -1131: two AFTER FIELD status clauses in the same statement

Corrected — combined into one clause

INPUT BY NAME order_id, status
  AFTER FIELD status
    LET v_x = 1
    LET v_y = 2
  END INPUT

Diagnostic Checks

Scan the statement for every AFTER FIELD clause, and check for any field name that appears more than once.

Related Errors / Related Topics

-1129 — "Field in BEFORE/AFTER clause not found in form." A related BEFORE/AFTER clause error, about a field name not resolving rather than being duplicated.
-1130 — "You cannot have multiple BEFORE clauses for the same field." The mirror-image restriction, for BEFORE FIELD rather than AFTER FIELD.

Only one AFTER FIELD clause per field is allowed — combine duplicates into a single clause.