Release 10.1A: OpenEdge Development:
Progress 4GL Reference

> ## IF...THEN...ELSE function

> Evaluates 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
>       BY IF balance > 10000 THEN 1
>       ELSE (IF balance > 1000 THEN 2 ELSE 3) BY sales-rep:
>       DISPLAY sales-rep balance name.
>     END.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095