number of decimals

[Mike]

How do I know the number of decimals in the numeric field in VFP?
Thanks for any help!
Mike.

[Eric den Doop]

Hello,

n = 0.12345
c = transform(n)
?len(c) - at(".", c)

Note that this will fail if n = 9.999, because for some reason:
?transform(9.999) = "9.999000000000001"

These weird results start at 9.992. I think it is a bug because
?transform(10.999) = "10.999"

This is VFP6 SP5
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts

"Mike" <mp@monarque.com> wrote in message news:3b39f3dc$1@news.devx.com...
>
>
> How do I know the number of decimals in the numeric field in VFP?
> Thanks for any help!
> Mike.
>

[Fred - Armoni]

Another solution is to use AFIELD(), ASCAN() and look at the 4th column.

Fred

Mike a écrit :
>
> How do I know the number of decimals in the numeric field in VFP?
> Thanks for any help!
> Mike.

--
FE AVP&Cie
Juillenay, Europe