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 will 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:







For further information on finding data that might require correcting, see this page.