Informix Error -3002

Reasons / Common Causes

-3002 fires when the View menu option is selected on a form with no TEXT/BYTE fields — per the official guidance, the View option lets you view the contents of TEXT and BYTE fields of a form, but this form has none.

1. The current form has no TEXT/BYTE (BLOB) fields, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Use the View option only on a form that has TEXT/BYTE fields defined, per the official guidance.

Examples

Checking a form's column types before viewing

SELECT colname, coltype FROM syscolumns c, systables t
  WHERE c.tabid = t.tabid AND t.tabname = 'orders'
  AND coltype IN (11, 12);
-- coltype 11 = BYTE, 12 = TEXT

Diagnostic Checks

1. Check whether the current form's table actually has TEXT/BYTE columns, before selecting View.

Related Errors / Related Topics

• -3003 — "This BLOB field is empty." A related BLOB-viewing error, about a BYTE field that exists but has no data, rather than a form with no BLOB fields at all.

The current form has no TEXT/BYTE fields to view — select View only on a form that has them.