Difference between revisions of "ICASE()"

Revision as of 15:39, 27 October 2009

Purpose

Function to execute an immediate case statement

Syntax

ICASE(<expL1>, <exp1>[, <expL2>, <exp2>] [,…] [, <exp-otherwise>)

See Also

DO CASE, IF, IF()

Description

The ICASE() function operates as an immediate DO CASE statement. It evaluates the specified conditions <expL1> to <expLn> and returns the matching expression <exp1> to <expn> for the first condition that evaluates to True (.T.). If none of the conditions evaluates to True, the 'otherwise' expression, <exp-otherwise>, is returned. If there is no otherwise expression specified, and none of the conditions evaluates to True, ICASE() returns a null (.NULL.).

Example

accept "Enter a command: " to command
&(icase(upper(command) = "BROWSE", "browse",;
 upper(command) = "DIR", "dir",;
 "Set message to [Unknown command.]"))

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer