Difference between revisions of "ICASE()"

From Lianjapedia
Jump to: navigation, search
m (Text replace - "Recital" to "Lianja")
Line 28: Line 28:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:Search Functions]]

Revision as of 23:36, 9 December 2012

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

Lianja Server, Lianja