Oninit
Talk to an expert →

Informix Error -3200

Cause and resolution

There are no rows in the current list.

You must first query the table before you execute the UPDATE, REMOVE, NEXT or PREVIOUS command.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-3200 fires when UPDATE, REMOVE, NEXT, or PREVIOUS is executed before any query has run in PERFORM — per the official guidance, the table must be queried first.

  1. UPDATE/REMOVE/NEXT/PREVIOUS attempted with no prior QUERY, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Query the table before executing UPDATE, REMOVE, NEXT, or PREVIOUS, per the official guidance.
Examples
Querying before navigating
QUERY
-- run the query first, then:
NEXT
Diagnostic Checks
  1. Check whether a query has been run in the current session before attempting row navigation or modification commands.
Related Errors / Related Topics

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

UPDATE/REMOVE/NEXT/PREVIOUS was attempted before any row was queried — run QUERY first.