Difference between revisions of "Mathematical Operators"

Revision as of 13:21, 24 March 2009

The Recital/4GL supports the use of the following Mathematical Operators:

Operator	Operation	Precedence	Data Types
()	Parentheses	1	N,C,D
**	Exponentiation	2	N
*	Multiplication	3	N
/	Division	3	N
%	Modulus/Remainder	3	N
+	Addition	4	N,C,D
-	Subtraction	4	N,C,D

When dealing with Character data types, the operators have the following definitions:

Operator	Operation
+	Concatenate the right hand string to the end of the left hand string.
-	Concatenate the right hand string to the end of the left hand string after trimming the left hand string of trailing spaces.

When dealing with Date data types, the operators have the following definitions:

Operator	Operation
-	Returns the interval between the two dates as a number of days.

? 2*3^2
        18
? 2*25%7
      1.00
? [Hello     ] - [ World]
Hello World
? date() + 30 - date()
        30

@@ Line 27: / Line 27: @@
 !Operator||Operation
 |-
-|&#043;||Concatenate the right hand string to the end of the left hand string
+|&#043;||Concatenate the right hand string to the end of the left hand string.
 |-
-|&#045;||Concatenate the right hand string to the end of the left hand string after trimming the left hand string of trailing spaces
+|&#045;||Concatenate the right hand string to the end of the left hand string after trimming the left hand string of trailing spaces.
+|-
+|}
+When dealing with Date data types, the operators have the following definitions:
+{| class="wikitable"
+!Operator||Operation
+|-
+|&#045;||Returns the interval between the two dates as a number of days.
 |-
 |}
@@ Line 42: / Line 53: @@
 ? [Hello     ] - [ World]
 Hello World
+? date() + 30 - date()
 </code>
 [[Category:Documentation]]
 [[Category:Reference]]