Informix Error -3035: The column column-name has changed column type. Build your form again.
Cause and resolution
The column column-name has changed column type. Build your form again.
The column column-name, which is named in the ATTRIBUTES section of the form, no longer has the data type that it had when the form was compiled (the table has been altered since). Check the present data type; then examine the form specification to make sure that it will display the column in a field of the appropriate size. Modify the form as required, and rebuild it.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-3035 fires at runtime when a column's data type no longer matches what it had when the form was compiled — per the official guidance, the table has been altered since compilation.
- The table was altered to change the column's data type, per the official guidance — the direct, only cause.
Solutions / Resolution
- Check the column's present data type, per the official guidance.
- Examine the form specification to confirm it displays the column in a field of the appropriate size, per the official guidance.
- Modify the form as required, and rebuild it, per the official guidance.
Examples
Checking a column's current data type
SELECT colname, coltype, collength FROM syscolumns c, systables t
WHERE c.tabid = t.tabid AND t.tabname = 'orders' AND c.colname = 'status';
Diagnostic Checks
- Check the column's current data type and length, and adjust the form's field sizing before rebuilding.
Related Errors / Related Topics
- -3030 — "The column column-name is not in the database." A related runtime schema-drift error, about a column that no longer exists at all rather than one whose type changed.
A column's data type has changed since the form was compiled — check the new type, adjust the form's field sizing, and rebuild.