Error Converting Data Type Varchar to Float

<< Click to Display Table of Contents >>

Navigation:  EnviroInsite > Frequently Asked Questions > Troubleshooting Error Messages >

Error Converting Data Type Varchar to Float

This problem only occurs when accessing an EQuIS database. The error occurs when EnviroInsite is unable to interpret a value in one or more fields as a numeric value. These two 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. Examine the following fields for this type of issue:

 

DT_COORDINATE.X_COORD

DT_COORDINATE.Y_COORD

DT_COORDINATE.ELEV

DT_WELL.TOP_CASING_ELEV