Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- RaSQL/B 6.1a for Clipper - <b>n_xdec()</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
N_XDEC()
Get number of decimal positions in specified field

Syntax
N_XDEC(<cField> | <nField>)

Argument
<Field> is a field, specified by name or by field number. If you use a field 
name, case is ignored.

Returns
Number of decimal positions in specified field.
If the field is not numeric or if an invalid field is specified, then the 
function returns zero.

Remarks
The number of decimal positions is defined when the table is opened with 
N_XUSE() or USE VIA.

Example
? N_XFETCH('amount_paid')
1000.00
? N_XDEC('amount_paid')
2


See Also: N_XFIELD() N_XLEN() N_XNUM()

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