Difference between revisions of "Working With Numeric Data in Recital"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) (→Numeric Conversion Functions) |
Yvonnemilne (Talk | contribs) (→Numeric Conversion Functions) |
||
| Line 30: | Line 30: | ||
<pre> | <pre> | ||
| − | numeric = abs(numeric) | + | numeric = abs(number as numeric) |
</pre> | </pre> | ||
* [[CAST()|cast()]] - perform data type conversion | * [[CAST()|cast()]] - perform data type conversion | ||
| + | |||
| + | <pre> | ||
| + | expression = cast(expression as expression AS datatype as character [, width as numeric [, precision as numeric]] [null | not null]) | ||
| + | </pre> | ||
| + | |||
* [[CHR()|chr()]] - perform numeric to ASCII character conversion | * [[CHR()|chr()]] - perform numeric to ASCII character conversion | ||
| + | |||
| + | <pre> | ||
| + | character = chr(number as numeric) | ||
| + | </pre> | ||
| + | |||
* [[CTRL()|ctrl()]] - return the numeric value of a control character | * [[CTRL()|ctrl()]] - return the numeric value of a control character | ||
| + | |||
| + | <pre> | ||
| + | numeric = ctrl(character) | ||
| + | </pre> | ||
| + | |||
* [[CURRENCY()|currency()]] - perform numeric to currency string conversion | * [[CURRENCY()|currency()]] - perform numeric to currency string conversion | ||
| + | |||
| + | <pre> | ||
| + | character = currency(numeric) | ||
| + | </pre> | ||
| + | |||
* [[ETOS()|etos()]] - perform expression to string conversion | * [[ETOS()|etos()]] - perform expression to string conversion | ||
| + | |||
| + | <pre> | ||
| + | character = etos(expression as expression) | ||
| + | </pre> | ||
| + | |||
* [[INT()|int()]] - return the integer value of a numeric | * [[INT()|int()]] - return the integer value of a numeric | ||
| − | * [[STR()|str()]] - perform numeric to string conversion | + | |
| + | <pre> | ||
| + | numeric = int(numeric) | ||
| + | </pre> | ||
| + | |||
| + | * [[STR()|str()]] - perform numeric to string conversion | ||
| + | |||
| + | <pre> | ||
| + | character = str(number as numeric [, width as numeric [, decimals as numeric [, base as numeric]]] ) | ||
| + | </pre> | ||
| + | |||
* [[STRZERO()|strzero()]] - perform numeric to zero left-padded string conversion | * [[STRZERO()|strzero()]] - perform numeric to zero left-padded string conversion | ||
| + | |||
| + | <pre> | ||
| + | character = strzero(number as numeric [, width as numeric [, decimals as numeric]]) | ||
| + | </pre> | ||
| + | |||
* [[TRANSFORM()|transform()]] - perform expression to string conversion based on a picture formatting clause | * [[TRANSFORM()|transform()]] - perform expression to string conversion based on a picture formatting clause | ||
* [[VAL()|val()]] - perform string to numeric conversion | * [[VAL()|val()]] - perform string to numeric conversion | ||
Revision as of 14:13, 22 January 2010
Contents
Working With Numeric Data in Recital
Certain set commands change the display format of numeric data:
- set decimals - specify the number of decimal places to be displayed
set decimals to <places as numeric>
- set fixed - determine whether the number of decimal places displayed is fixed
set fixed on | off
- set point - specify the character to be used as the decimal point
set point to [<point as character>]
- set separator - specify the character to be used to mark thousands
set separator to [<separator as character>]
Numeric Conversion Functions
- abs() - return the absolute value of a numeric
numeric = abs(number as numeric)
- cast() - perform data type conversion
expression = cast(expression as expression AS datatype as character [, width as numeric [, precision as numeric]] [null | not null])
- chr() - perform numeric to ASCII character conversion
character = chr(number as numeric)
- ctrl() - return the numeric value of a control character
numeric = ctrl(character)
- currency() - perform numeric to currency string conversion
character = currency(numeric)
- etos() - perform expression to string conversion
character = etos(expression as expression)
- int() - return the integer value of a numeric
numeric = int(numeric)
- str() - perform numeric to string conversion
character = str(number as numeric [, width as numeric [, decimals as numeric [, base as numeric]]] )
- strzero() - perform numeric to zero left-padded string conversion
character = strzero(number as numeric [, width as numeric [, decimals as numeric]])
- transform() - perform expression to string conversion based on a picture formatting clause
- val() - perform string to numeric conversion
Miscellaneous Numeric Functions
- acos() - calculate the angle size in radians of a cosine
- asin() - calculate the angle size of any given sine value
- atan() - calulate the angle size of a given tangent value
- atn2() - calculate the angle size for the specified cosine and sine values of a given point
- between() - determine whether an expression is between two other specified expressions
- celing() - calculate the smallest integer that is greater than or equal to a given value
- cos() - calculate the cosine of an angle in radians
- dtor() - perform degree to radian conversion
- exp() - calculate exponential value
- floor() - calculate the largest integer that is less than or equal to a given number
- lennum() - calculate the length of a numeric value
- log() - calculate natural logarithm value
- log10() - calculate base 10 logarithm value
- max() - calculate the greater of two values
- min() - calculate the lesser of two values
- mod() - calculate the division remainder
- percent() - calculate percentage
- pi() - return the value of pi
- rand() - return a random number
- round() - return a rounded numeric
- rtod() - perform radian to degree conversion
- sign() - return the sign of a numeric value
- sin() - calculate the sine of an angle in radians
- sqrt() - calculate a square root
- tan() - calculate the tangent of an angle in radians
