Evaluates and returns one of two expressions, depending
on the value of a specified condition.
Syntax
IF condition THEN expression1 ELSE expression2
|
-
condition
- An expression whose value is logical (TRUE or FALSE).
-
expression1
- A constant, field name, variable name, or expression. If the condition is
TRUE, then the function returns this value.
-
expression2
- A constant, field name, variable name, or expression whose value
is of a data type that is compatible with the data type of expression1.
If the condition is FALSE or the Unknown value (?),
then the function returns this value.
Example
You
can use the IF . . . THEN . . . ELSE function when you want to sort records
in an unusual order. In this example, the Customers are sorted so
that those with a Balance greater than $10,000 appear first, then
those with Balances between $1,000 and $10,000, and finally those
with Balance of $1,000 or less:
r-ifelsf.p
FOR EACH Customer NO-LOCK BY IF Customer.Balance > 10000 THEN 1
ELSE (IF Customer.Balance > 1000 THEN 2 ELSE 3) BY Customer.SalesRep:
DISPLAY Customer.SalesRep Customer.Balance Customer.Name.
END.
|