Oninit
Talk to an expert →

Informix Error -3200: There are no rows in the current list.

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.