Informix Error -3020: The table table-name is not in the database. Build your form again.

Reasons / Common Causes

-3020 fires at runtime when a table listed in a form's TABLES section can no longer be found in the database — per the official guidance, this happens if the form is using the wrong database, or the table has been dropped or renamed since the form was compiled.

1. The form's DATABASE statement points to the wrong database, per the official guidance — the first named cause.
2. The table was dropped or renamed since the form was compiled, per the official guidance — the second named cause.

Solutions / Resolution

1. Review the DATABASE statement to ensure the form is using the correct database, per the official guidance.
2. Use Informix SQL's Info selection in the Tables menu to check table names, per the official guidance.
3. Revise the form to use the correct name, and rebuild it, per the official guidance.

Examples

Checking the actual table names

SELECT tabname FROM systables WHERE tabtype = 'T';

Diagnostic Checks

1. Check the form's DATABASE statement, and confirm the table still exists (or find its new name) via Informix SQL's Tables menu.

Related Errors / Related Topics

• -3030 — "The column column-name is not in the database." A related runtime schema-mismatch error, about a missing column rather than a missing table.

A table listed in the form's TABLES section is no longer in the database — check the DATABASE statement and whether the table was dropped or renamed, then rebuild the form.