Oninit
Talk to an expert →

Informix Error -1129

-1129 Field in BEFORE/AFTER clause not found in form.

This statement includes a BEFORE FIELD clause or an AFTER FIELD clause that names a field that is not defined in the form that is currently displayed. Review the program to ensure that the intended form was displayed, and review this statement against the form specification to ensure that existing fields are named. Also see the note on field names for error message -1102.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-1129 fires when a BEFORE FIELD or AFTER FIELD clause references a field name that doesn't exist in the currently displayed form — per the official guidance, this is a name-resolution problem against the active form, similar in nature to -1119's NEXT FIELD case.

  1. A BEFORE FIELD/AFTER FIELD clause referencing a field name absent from the current form, per the official guidance — the direct, only cause.
  2. The wrong form actually displayed, per the official guidance's suggested check — the field might exist in a different form than the one currently active.
Solutions / Resolution
  1. Verify the correct form is displayed, per the official guidance.
  2. Confirm the field names in the statement match those defined in the form specification, per the official guidance.
Examples
A stale BEFORE FIELD reference
INPUT BY NAME order_id, status
  BEFORE FIELD customer_num
    ...
  END INPUT
-- -1129: the current form has no field named customer_num
Diagnostic Checks
  1. Confirm the correct form is displayed, and check every BEFORE FIELD/AFTER FIELD clause's referenced field name against its ATTRIBUTES section.
Related Errors / Related Topics
  • -1102 — "Field name not found in form." A related form-processing error, about a general field reference not resolving.
  • -1119 — "NEXT FIELD name not found in form." A related field-clause error, about NEXT FIELD specifically rather than BEFORE/AFTER FIELD.

A BEFORE FIELD/AFTER FIELD clause references a field absent from the current form — verify the right form is displayed and the field name matches.