DSXchange

Posted: **Thu Feb 05, 2009 12:36 pm**

I have a VALUE field of 38,10 and I am using the trim(DecimalToString(mv_CRAFTOUT.VALUE ,"suppress_zero")) but I am still getting this error

xfmLoadDS,1: Conversion error converting input field VALUE to output field VALUE, data may have been lost [transform/tfmop_functions.C:131]

I have increased the varchar field to 100 and it still shows the error.

Posted: **Thu Feb 05, 2009 12:45 pm**

38,10 is not a valid decimal. 38.10 would be

Posted: **Thu Feb 05, 2009 12:46 pm**

38,10 is not a valid decimal. 38.10 would be

Posted: **Thu Feb 05, 2009 12:49 pm**

Length 38 scale 10 same as 38,10

Posted: **Thu Feb 05, 2009 12:59 pm**

I think radarada means "decimal[38,10]" rather than 38,10 as the value.

Even so, in most European locales, 38,10 IS a valid decimal number.