Difference between revisions of "SET SEPARATOR"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
Line 15: | Line 15: | ||
==See Also== | ==See Also== | ||
− | SET DECIMAL, SET | + | [[SET DECIMAL]], [[SET POINT]], [[SET PRECISION]] |
Line 23: | Line 23: | ||
==Example== | ==Example== | ||
− | < | + | <code lang="recital"> |
set point to "," | set point to "," | ||
set separator to "." | set separator to "." | ||
@1,1 say ord_value picture "999.999.999.99" | @1,1 say ord_value picture "999.999.999.99" | ||
− | 1.234.567,89</ | + | 1.234.567,89</code> |
==Products== | ==Products== | ||
Recital Database Server, Recital Mirage Server, Recital Terminal Developer | Recital Database Server, Recital Mirage Server, Recital Terminal Developer | ||
+ | [[Category:Documentation]] | ||
+ | [[Category:Commands]] | ||
+ | [[Category:Set_Commands|SEPARATOR]] |
Revision as of 12:04, 12 March 2009
Contents
SET SEPARATOR
Class
Numeric Data
Purpose
Change the character used to mark thousands
Syntax
SET SEPARATOR TO [<expC>]
See Also
SET DECIMAL, SET POINT, SET PRECISION
Description
The SET SEPARATOR TO command changes the thousand mark character from a comma to the character specified by <expC> and is used in conjunction with a picture statement or clause. This command, along with SET POINT, is typically used to change the way a decimal is written from 123,456.98 to 123.456,98. In order for the SET SEPARATOR command to work properly when outputting with @...SAYS or ?, a picture must be used that conforms to the setting of SET POINT and SET SEPARATOR. If <expC> is more than one character long, the SET SEPARATOR command will only use the first character in the string. When used without a character expression, the SET SEPARATOR command changes the thousand mark character back to the default of a comma (,).
Example
set point to "," set separator to "." @1,1 say ord_value picture "999.999.999.99" 1.234.567,89
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer