Informix Error -1106
-1106 Error in field.
You entered a value in this field that cannot be stored in the program variable that is meant to receive it. For example, possibly you entered a decimal number when the application provided only an integer variable, or you entered a character string that is longer than the application expected. Note all the circumstances and then discuss the problem with the person who wrote the application program.
For 4GL programs, -1304 replaces this error.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-1106 fires when a value entered into a field can't be stored in the program variable meant to
receive it — per the official guidance, an example is entering a decimal number where the
application provided only an integer variable, or a character string longer than the variable
can hold; -1304 is the equivalent error for 4GL programs specifically.
- A value whose type doesn't fit the receiving variable's declared type, per the official guidance's example (a decimal entered for an integer field) — the direct, common cause.
- A character string longer than the receiving variable's declared length, per the official guidance's other named example.
Solutions / Resolution
- Enter a value that matches the receiving variable's type and length, per the official guidance.
- If the value should genuinely be accepted, widen the program variable's declared type or length to accommodate it, and update the form specification to match.
Examples
A value that doesn't fit the variable
-- program variable: DEFINE v_quantity INTEGER;
-- entered value: 3.5
-- -1106: 3.5 cannot be stored in an INTEGER variable
Diagnostic Checks
- Check the receiving program variable's declared type and length against the value that was entered.
Related Errors / Related Topics
- -1304 — The 4GL-program equivalent of this same type/length mismatch.
The entered value doesn't fit the receiving variable's type or length — enter a matching value, or widen the variable (see -1304 for the 4GL-program equivalent).