Informix Error -3260

-3260 This is an invalid value -- it does not exist in table-name table.

This column has a verify join with a column in table table-name. Any value that is entered in this field must be found in that table. The value just entered was not found. Enter a correct value.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-3260 fires at data-entry time when a value entered into a verify-join field isn't found in the joined table — per the official guidance, the column has a verify join with a column in table-name, and any value entered must be found there.

The entered value doesn't exist in the verify-join's target table, per the official guidance — the direct, only cause.

Solutions / Resolution

Enter a correct value, per the official guidance — one that actually exists in table-name.

Examples

Checking valid values in the joined table

SELECT cust_id FROM customer WHERE cust_id = '12345';
-- if this returns nothing, '12345' is not a valid value to enter

Diagnostic Checks

Check whether the entered value exists in the verify-join's target table, and correct it if not.

Related Errors / Related Topics

-3261 — "Invalid value -- its composite value does not exist in table-name table." The same verify-join lookup failure, applied to a COMPOSITE (multi-column) join rather than a single column.

A value entered into a verify-join field doesn't exist in the joined table — enter a value that does.