Get Well List - Error Converting Varchar to Float

<< Click to Display Table of Contents >>

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

Get Well List - Error Converting Varchar to Float

This problem only occurs when accessing an EQuIS database. The error occurs when EI is unable to interpret a value in one of two fields (DT_COORDINATE.X_COORD or DT_COORDINATE.Y_COORD) as a numeric value. These two fields are defined as text fields in EQuIS, but carry numeric values describing the location's coordinates. 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.