Difference between revisions of "SET FIXED"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Determines whether a fixed number of decimal places are displayed for numeric output | Determines whether a fixed number of decimal places are displayed for numeric output | ||
− | |||
==Syntax== | ==Syntax== | ||
SET FIXED ON | OFF | (<expL>) | SET FIXED ON | OFF | (<expL>) | ||
− | |||
==See Also== | ==See Also== | ||
[[ABS()]], [[FIXED()]], [[INT()]], [[ROUND()]], [[SET DECIMALS]] | [[ABS()]], [[FIXED()]], [[INT()]], [[ROUND()]], [[SET DECIMALS]] | ||
− | |||
==Description== | ==Description== | ||
If SET FIXED is ON, then all numeric output will be displayed with the number of decimal places specified by the SET DECIMALS command. If no SET DECIMALS command has been issued, then the number of decimal places displayed will be 2. By default, FIXED is OFF. | If SET FIXED is ON, then all numeric output will be displayed with the number of decimal places specified by the SET DECIMALS command. If no SET DECIMALS command has been issued, then the number of decimal places displayed will be 2. By default, FIXED is OFF. | ||
− | |||
==Example== | ==Example== | ||
Line 23: | Line 19: | ||
? 285.129 * 4.6 | ? 285.129 * 4.6 | ||
1311.593</code> | 1311.593</code> | ||
− | |||
==Products== | ==Products== |
Revision as of 12:20, 12 December 2012
Purpose
Determines whether a fixed number of decimal places are displayed for numeric output
Syntax
SET FIXED ON | OFF | (<expL>)
See Also
ABS(), FIXED(), INT(), ROUND(), SET DECIMALS
Description
If SET FIXED is ON, then all numeric output will be displayed with the number of decimal places specified by the SET DECIMALS command. If no SET DECIMALS command has been issued, then the number of decimal places displayed will be 2. By default, FIXED is OFF.
Example
? 285.129 * 4.6 1311.5934 set decimals to 3 set fixed on ? 285.129 * 4.6 1311.593
Products
Lianja Server, Lianja