Topic group Related topics
Returns the number of decimal places in a specified field of a table.
FDECIMAL(<field number expN> [, <alias>])
<field number expN>
The position of the field that you want to evaluate. The first field in a table is field number 1.
The work area that contains the field to check.
FDECIMAL( ) returns the number of decimal places in a specified field of a table. FDECIMAL( ) returns zero if the field has no decimal places, if the field is not a numeric field, or if the table doesn't contain a field in the specified position.
Check the decimalLength property of the Field object.