Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- Clipper Tools One Guide - <b>fielddeci()</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
FIELDDECI()

Syntax:     FIELDDECI(<expN>)

Arguments:  <expN> denotes the number of the field to evaluate.

Returns:    A numeric value.
            The number of decimal places in the numerical field.

Usage:      It is frequently important to know the number of decimal
            places in a field in order to restrict the input correspondingly.
            Use FIELDDECI() to determine the number of decimal places
            available.  It is then possible to adapt input to the database
            used, without having to change the program.

Notes:      The function will return a 0 if the field number is negative,
            out of range, or if the field type is not numeric.

Library:    CT1.LIB


--------------------------------- Example ------------------------------

Examples:   numfield = FIELD(2)
            ? "Numfield" + " " + STR(&numfield,8,FIELDDECI(2))



See Also: FIELDSIZE() FIELDTYPE()

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson