English

Error: Value does not match column type

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]