Record Count - Error Converting Data Type Varchar to Float
Copyright © 2019 EarthSoft, Inc • Modified: 12 Nov 2019
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.