Conversion error converting input field

radarada · Post by **radarada** » 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.

mfavero · Post by **mfavero** » Thu Feb 05, 2009 12:45 pm

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

mfavero · Post by **mfavero** » Thu Feb 05, 2009 12:46 pm

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

radarada · Post by **radarada** » Thu Feb 05, 2009 12:49 pm

Length 38 scale 10 same as 38,10

ray.wurlod · Post by **ray.wurlod** » 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.