Previous Topic: IDCMCEXP08 - An alphanumeric field in a WHERE clause can not be compared to a numeric field or numeric literalNext Topic: IDCMCEXP10 - Left-hand operand in WHERE clause must be a field from the object dataview

Compile (CM) Messages › › IDCMCEXP09 - A numeric field or numeric literal is being compared to an alphanumeric field

IDCMCEXP09 - A numeric field or numeric literal is being compared to an alphanumeric field

Reason:

If the alphanumeric field cannot be converted to numeric data as documented in the $NUMBER function, a RUN-time error could result.

Action:

Assure that the data in the alphanumeric field is in a format acceptable to the $NUMBER function. Alternately, change the comparison so that the alphanumeric field is compared to an alphanumeric literal or expression or so that a numeric field is compared to a numeric literal or expression.