Converting Text value to decimal value

[newpgm]

I am using CDec but it is not working.. In my table I defined ct_num as decimal with precision as 7 and scale as 2
when I run this it shows error message 3759 " Scaling of decimal value resulted in data truncation.
ct_num=CDec(ct_val)

If I use CInt or CLng it is rounding the number. say 19.24 is saved as 19.

Any thoughts?

 

[SkipVought]

Hi,

Little code snippets will not do.

Please post ALL your relevent code, including variable declarations.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Bong]

True, but "CDbl" might be worth a shot.

_________________
Bob Rashkin