>>>Is there a function that can retrieve the number of decimal places that a given field has? For example, if I have a cursor with Field1 N (6,2), then TYPE('Field1') would be 'N' and FSIZE ('Field1') would be 6. How can I get the 2 for the decimals?
>>
>>See
http://www.berezniker.com/content/pages/visual-foxpro/how-check-if-variable-integer>
>Sergey,
>
>All solutions based on the value in the field, they require that field is populated according to its length and decimal places.
>and value does have decimal places. Meanwhile one can populate N(5,3) with integer 12345 having no decimal places.
>
>$0.02
I was thinking exactly that too. Afields seems to be the only 100% reliable solution for a table field.
If it's not broken, fix it until it is.
My Blog