Oninit
Talk to an expert →

Informix Error -3450: Someone else has deleted a row which is in your list.

Cause and resolution

Someone else has deleted a row which is in your list.

Another user, accessing a table that is queried by your form, has deleted a row that your latest query selected. Restart your query to get an accurate selection of rows. Version 4.0 and earlier of PERFORM might return this error message when you query a view. Early versions of the product did not support views.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-3450 fires when another user deletes a row that's part of the current query's result list — per the official guidance, this affects any row in the list, not just the one currently displayed. The official guidance also notes PERFORM 4.0 and earlier could raise this error when querying a view, since early versions didn't support views.

  1. Another user deleted a row that's part of the current query's result list, per the official guidance — the direct, only cause.
  2. Querying a view under PERFORM 4.0 or earlier, per the official guidance — a version-specific historical cause, since views weren't supported.
Solutions / Resolution
  1. Restart the query to get an accurate selection of rows, per the official guidance.
Examples
Restarting the query
QUERY
-- re-run the query to refresh the list after another user's deletion
Diagnostic Checks
  1. Restart the query whenever this error appears, rather than trying to continue with the stale list.
Related Errors / Related Topics
  • -3210 — "The current row position contains a deleted row." A closely related concurrent-deletion error, about the specific row currently displayed rather than any row elsewhere in the query's result list.

Another user deleted a row in the current query's result list — restart the query.