User Tools

Site Tools

Navigation:  Language Reference > 13 - Built-in Functions >====== CHOOSE (return chosen value) ====== Previous pageReturn to chapter overviewNext page
CHOOSE( expression ,value, value [,value…] )
condition [,truevalue, falsevalue ]


CHOOSE Returns the chosen value from a list of possible values.
expression An arithmetic expression which determines which value parameter to return. This expression must resolve to a positive integer.
value A variable, constant, or expression for the procedure to return.
condition A logical expression which determines which of the two value parameters to return. If no truevalue or falsevalue parameters are present, one (1) is returned when the expression is true, and zero (0) is returned when the expression is false.

The CHOOSE procedure evaluates the expression or condition and returns the appropriate value parameter. If the expression resolves to a positive integer, that integer selects the corresponding value parameter for the CHOOSE procedure to return. If the expression evaluates to an out-of-range integer, then CHOOSE returns the last value parameter.

When the condition evaluates as true, then CHOOSE returns the truevalue parameter. When the condition evaluates to false, then CHOOSE returns the second falsevalue parameter. If no value parameters are present, CHOOSE returns one (1) for true, and zero (0) for false.

The return data type is dependent upon the data types of the value parameters:

All Value Parameters       Return Data Type

 LONG                      LONG


 STRING                    STRING


 anything else             REAL

Return Data Type: LONG, DECIMAL, STRING, or REAL


CHOOSE(4,'A','B','C','D','E')  returns 'D'
CHOOSE(1 > 2,'A','B')          returns 'B'
CHOOSE(1 > 2)                  returns zero (0)
!Hide or unhide control, based on the value in SomeField:
?MyControl{PROP:Hide} = CHOOSE(SomeField = 0,TRUE,FALSE)
!VIEW filter to select “overweight” people of both sexes
MyView{PROP:Filter} = 'Weight > CHOOSE(Sex = M,250,200)'
CHOOSE(Date % 7 + 1,'Sunday','Monday','Tuesday','Wednesday', |
CHOOSE(Date % 7 + 1,'Sun','Mon','Tue','Wed','Thu','Fri','Sat')
CHOOSE(Date % 7 % 6 + 1,'Weekend','Weekday')
CHOOSE(INRANGE(Date % 7,1,5),'Weekend','Weekday')

See Also:


choose_return_chosen_value_.htm.txt · Last modified: 2021/04/15 15:57 by