Progress
Language Reference


IF...THEN...ELSE Function

Interfaces
OS
SpeedScript
All
All
Yes

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 unknown (?), 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 © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095