Oninit
Talk to an expert →

Informix Error -1130

-1130 You cannot have multiple BEFORE clauses for the same field.

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

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-1130 fires when a statement includes two or more BEFORE FIELD clauses naming the same form field — per the official guidance, only one BEFORE FIELD clause per field is supported.

  1. Two or more BEFORE FIELD clauses in the same statement naming the same field, per the official guidance — the direct, only cause, often from logic being added incrementally without noticing an earlier clause already covers that field.
Solutions / Resolution
  1. Find all the BEFORE FIELD clauses relating to one field, and combine them into a single clause, per the official guidance.
Examples
Duplicate BEFORE FIELD clauses
INPUT BY NAME order_id, status
  BEFORE FIELD status
    LET v_x = 1
  BEFORE FIELD status
    LET v_y = 2
  END INPUT
-- -1130: two BEFORE FIELD status clauses in the same statement
Corrected — combined into one clause
INPUT BY NAME order_id, status
  BEFORE FIELD status
    LET v_x = 1
    LET v_y = 2
  END INPUT
Diagnostic Checks
  1. Scan the statement for every BEFORE 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.
  • -1131 — "You cannot have multiple AFTER clauses for the same field." The mirror-image restriction, for AFTER FIELD rather than BEFORE FIELD.

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