FDECIMAL( )

Topic group Related topics

Returns the number of decimal places in a specified field of a table.

Syntax

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.

<alias>

The work area that contains the field to check.

Description

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.

OODML

Check the decimalLength property of the Field object.