ODBC NaN -1.#IND


#1

Hello, I was wondering if anyone might be able to help me. I am using the Clarion ODBC driver to connect our topspeed files to Microsoft Access. We get a lot of “-1.#IND” in our fields, where they display as “0” in the Topspeed viewer. After some looking into, it seems that these “-1.#IND” and “-1.#INF” fields are NaNs. I am wondering if anyone else has seen this, or if anyone has any resolution to treat these as zeroes or nulls.

Thank you