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

Reasons / Common Causes

-3030 fires at runtime when a column named in a form's ATTRIBUTES section no longer exists in its table — per the official guidance, the table itself still exists, but the column doesn't, typically because the table was altered or the column was renamed.

1. The table was altered to remove the column, per the official guidance — the first named cause.
2. The column was renamed, per the official guidance — the second named cause.

Solutions / Resolution

1. Check the spelling of column-name against the actual table, per the official guidance.
2. Use Informix SQL's Info selection in the Tables menu to check column names, per the official guidance.
3. Revise the form to use the correct column name, and rebuild it, per the official guidance.

Examples

Checking a table's actual columns

SELECT colname FROM syscolumns c, systables t
  WHERE c.tabid = t.tabid AND t.tabname = 'orders';

Diagnostic Checks

1. Check whether the column still exists on the table, via Informix SQL's Tables menu or a direct syscolumns query, and rebuild the form with the correct name.

Related Errors / Related Topics

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

A column named in the form's ATTRIBUTES section no longer exists on its table — check whether it was altered or renamed, then rebuild the form.