Oninit
Talk to an expert →

Informix Error -1164

-1164 A NEXT FIELD specified in the instructions section of the form is

not used within the current input statement.

The current form field has a NEXT FIELD specification (in the INSTRUCTIONS section of the form). However, the specified next field is not named in the current INPUT statement, so the cursor cannot move to that field.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-1164 fires when a form field's INSTRUCTIONS section specifies a NEXT FIELD, but the target field named there isn't included in the current INPUT statement's own field list — per the official guidance, this prevents the cursor from navigating to that field as intended.

  1. A form field's INSTRUCTIONS-section NEXT FIELD naming a field absent from the current INPUT statement's field list, per the official guidance — the direct, only cause.
  2. The INPUT statement's field list changed (a field removed) without updating the form's INSTRUCTIONS-section NEXT FIELD to match.
Solutions / Resolution
  1. Include the NEXT FIELD target in the current INPUT statement's field list, or update the form's INSTRUCTIONS section to name a field that actually is included.
Examples
A NEXT FIELD target missing from the INPUT statement
-- form's INSTRUCTIONS section for field "status":
--   NEXT FIELD customer_num;
INPUT BY NAME order_id, status FROM s_order.*
-- -1164: customer_num isn't part of this INPUT statement's field list
Diagnostic Checks
  1. Compare the form's INSTRUCTIONS-section NEXT FIELD targets against the current INPUT statement's actual field list.
Related Errors / Related Topics
  • -1119 — "NEXT FIELD name not found in form." A related NEXT FIELD error, about the field not existing in the form at all rather than simply being excluded from the current statement.
  • -1129 — "Field in BEFORE/AFTER clause not found in form." A related field-clause error, for BEFORE/AFTER FIELD rather than a form-level NEXT FIELD instruction.

The form's INSTRUCTIONS-section NEXT FIELD target isn't part of the current INPUT statement's field list — include it, or point the instruction at a field that is.