%META:TOPICPARENT{name="ErrorMessagesU"}%

==Error Messages (U)==

[[UDAErrorMessages|A]] [[ErrorMessagesB|B]] [[ErrorMessagesC|C]] [[ErrorMessagesD|D]] [[ErrorMessagesE|E]] [[ErrorMessagesF|F]] [[ErrorMessagesG|G]] [[ErrorMessagesH|H]] [[ErrorMessagesI|I]] [[ErrorMessagesJ|J]] [[ErrorMessagesK|K]] [[ErrorMessagesL|L]] [[ErrorMessagesM|M]] [[ErrorMessagesN|N]] [[ErrorMessagesO|O]] [[ErrorMessagesP|P]] [[ErrorMessagesQ|Q]] [[ErrorMessagesR|R]] [[ErrorMessagesS|S]] [[ErrorMessagesT|T]] [[ErrorMessagesU|U]] [[ErrorMessagesV|V]] [[ErrorMessagesW|W]] [[ErrorMessagesX|X]] [[ErrorMessagesY|Y]] [[ErrorMessagesZ|Z]] [[ErrorMessagesSymbols|#]]

===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
  
|