Difference between revisions of "SET SEPARATOR"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 15: Line 15:
  
 
==See Also==
 
==See Also==
SET DECIMAL, SET PRECISION , SET POINT
+
[[SET DECIMAL]], [[SET POINT]], [[SET PRECISION]]
  
  
Line 23: Line 23:
  
 
==Example==
 
==Example==
<pre>
+
<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</pre>
+
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

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