Record Count - Error Converting Data Type Varchar to Float

<< Click to Display Table of Contents >>

EQuIS 7  >>  EnviroInsite > Frequently Asked Questions > Troubleshooting Error Messages >

Record Count - Error Converting Data Type Varchar to Float

This problem only occurs when accessing an EQuIS database. The error occurs when EI is unable to interpret a value in a field as a numeric value. Some fields are defined as text fields in EQuIS, but carry numeric values. EnviroInsite’s queries expect these fields to be either null or to contain a number. If they contain a text string that cannot be converted to a number, then you get this error. For instance, this may occur if the letter "O" is accidentally entered in place of the number zero. Another common error is to have one or more spaces at the front- or tail-end of the value in the field. Take a look at the following fields and see if you can find anything of this sort.

 

DT_COORDINATE.X_COORD

DT_COORDINATE.Y_COORD

DT_COORDINATE.ELEV

DT_WELL.TOP_CASING_ELEV