set precision of

Examples


The set precision of statement sets the number of decimal places in a specified currency or variable currency field to the value of an expression.

Syntax

set precision of {field} field_name to expression

Parameters

field – Identifies field_name to follow as the name of a field.

field_name The currency or variable currency field for which the number of decimal places will be set.

expression – An integer indicating the number of decimal places to be used. For currency fields, the allowable range to the right of the decimal separator is 0 to 5. For variable currency fields, it is 0 to 15.

Comments

The set precision of statement doesn’t change the value of data in a table; it affects only how the data is displayed in a window. Currency values displayed with fewer than the existing number of decimal places will be truncated, not rounded.

If a currency field has a linked format, that format will override the set precision of statement. Refer to The Multiple Format Selector for more information about linked formats.


Documentation Feedback