ICASE()

From Recital Documentation Wiki
Revision as of 15:39, 27 October 2009 by Helengeorge (Talk | contribs)

Jump to: navigation, search


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