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