Value does not match column type

Last Published: April 25, 2020

Error Message

Attempting to update a column within a DBMS table with an exponential value produces:

Value does not match column type
Arc: &sv :simplecur.test = 0.001E+00


The exponential value is not being interpreted as a decimal value.

Solution or Workaround

Multiply the exponential value being inserted by 1.

Arc: &sv :simplecur.test = [calculate 0.001E+00 * 1]

Article ID:000002932

  • ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic