Tagged Value wrong Values

[reherz]

Hi,

i have two different customized Tagged Value Fields of Type Decimal and Problems with the Data in both fields

--> While editing and reading information in Element Properties / Tagged Values the value of the field is "0,0" (or a different value)
--> requesting the value via SQL or in Generated Documents the value changes to e.g. "1,9853888367081E-120"

Why are there two different values? How can I request the right value?
Bizarrely not all values are different, some values are the same in both requesting ways.

Thanks!

- I'm using EA 12.1 -

[qwerty]

That's the nature of floats in a digital world. For all A, B element R: identity is defined if abs(A-B) < epsilon. And 1E-120 looks very close to that epsilon.

q.

[VKN]

How can I request the right value?

As a workaround, you can change your system's decimal separator to a period (.)