Informix Error -3400: There are no rows satisfying the conditions.

Reasons / Common Causes

-3400 fires when a QUERY finds no rows matching the entered search criteria — per the official guidance, no rows in the database match the values entered in the form.

1. No rows in the database match the entered query criteria, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Enter different values, and query again, per the official guidance.

Examples

Broadening a query

SELECT * FROM orders WHERE cust_id = '99999';
-- returns nothing if no such customer exists; try a different or
-- partial value instead

Diagnostic Checks

1. Check whether the entered search values are actually expected to match any row, and broaden or correct them before re-querying.

Related Errors / Related Topics

• -3200 — "There are no rows in the current list." A related no-rows error, about navigation commands being attempted with no query run at all, rather than a query itself returning zero matches.

The query's entered criteria matched no rows — enter different values and query again.