>Hello All,
>We're trying to figure out if there is a decimal in a numeric field.
>After checking with type() and fsize() (with set comp off to find field size), How do we find how many decimal places there are. We are trying to avoid the use of afields() function here. We can't use str() because it seems to stop at the decimal point. We can't take the val(str(thisvalue)) and substract it because 125 - 125.00 is still 0.
>
>Any ideas would be most appreciated!!
>
>Sandy

Take a look at the AFields() function - it places complete structure into an array, including (columns left to right) field name, field type, field length, decimals, and then some dozen other columns related to various DBGetProp() values.