ERROR

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

Cause

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

Solution or Workaround



Multiply the exponential value being inserted by 1.

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

Article ID:000002932

Software:
  • ArcMap 8 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options