Error Messages (U)

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

Use integer function to compare index-field and decimal

The "use integer function to compare index-field and decimal" error message occurs when queries compare fields with differing datatypes. If you experience "integer function" errors, use the INTEGER( ) function to convert non-integer datatypes to integer. For example:

SELECT * FROM TABLE WHERE INTFIELD >= 3.5 (wrong)

SELECT * FROM TABLE WHERE INTFIELD >= INTEGER(3.5) (correct)

Be advised. If you proceed, all decimal values will be rounded off and precision will be lost.

Evidence

ODBC Client Trace
Table Schema