Informix Error -3760

Cause and resolution

Matching may not be used between non-character fields or expressions.

An IF-THEN-ELSE statement in the INSTRUCTIONS section of the form uses the keyword MATCHES to compare two fields. However, at least one of the fields is not a character field, and you can use MATCHES only with character fields. Review all uses of MATCHES in the INSTRUCTIONS section to make sure it is applied only to character fields.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-3760 fires when an IF-THEN-ELSE statement in INSTRUCTIONS uses MATCHES to compare a non-character field — per the official guidance, MATCHES can only be used with character fields.

MATCHES applied to a non-character field or expression, per the official guidance — the direct, only cause.

Solutions / Resolution

Review all uses of MATCHES in the INSTRUCTIONS section, per the official guidance, to make sure it's applied only to character fields.

Examples

MATCHES on a non-character field

INSTRUCTIONS
  AFTER FIELD order_id
    IF order_id MATCHES "1*" THEN
      ...
    END IF
  END
END
-- -3760: order_id is INTEGER, not a character field

Corrected

INSTRUCTIONS
  AFTER FIELD order_ref
    IF order_ref MATCHES "1*" THEN
      ...
    END IF
  END
END
-- order_ref is CHAR

Diagnostic Checks

Check every MATCHES comparison in INSTRUCTIONS, and confirm both operands are character fields or expressions.

Related Errors / Related Topics

No closely related error codes are cross-referenced for -3760 in this set yet.

MATCHES was applied to a non-character field — it only works with character fields or expressions.