Type
Punctuation Symbol

Purpose
Parentheses are used as separators in selection criteria and function arguments and to clarify the sequence of mathematic operations. The use of parentheses is especially important when combining selection criteria using the and and or operators or when clarifying the order of evaluation of otherwise ambiguous expressions and operations.

Example
for MEMBERS with TOTAL DUE > 75 and
( STATE = "NY" or STATE = "NJ" ) ;
list records
LAST NAME in order ;
TOTAL DUE ;
STATE .
end

With the parentheses placed as shown, this script tells DataEase to list all the members from either New York or New Jersey whose TOTAL DUE is greater than $75
The report output from this script, arranged alphabetically by LAST NAME, might look as follows:

Last Name
Total Due
State
Baldwin
100.00
NY
Crandall
85.00
NY
Fitzpatrick
100.00
NY
Morales
115.00
NY
Morrison
100.00
NJ
Parker
105.00
NJ
Rutschow
100.00
NY
Stone
100.00
NY

Without parentheses, this script is ambiguous (it could be interpreted as all New York members whose total due is greater than $75 and all New Jersey members).
In the absence of parentheses, the default order of evaluation is: multiplication and division operations, addition and subtraction operations, comparison operators, and finally, the and and or operators. When operations of equal priority are involved, the expression is evaluated from left to right. When evaluating expressions in nested parentheses, the innermost expressions are evaluated first.