Filemaker Upgrade to FileMaker Pro 8.5 VLA Tier 2 + Maintenance TG782Z/A Manuel D’Utilisation
Codes de produits
TG782Z/A
128 FileMaker Functions Reference
Case
Format
Case(test1;result1{;test2;result2;defaultResult...})
Parameters
test - any text or numeric
.
result - result corresponding to the expression.
Parameters in curly braces { } are optional.
Parameters in curly braces { } are optional.
Data type returned
text, number, date, time, timestamp, container
Description
Returns one of several possible results based on a series of tests.
The Case function evaluates each test expression in order, and when a True expression
The Case function evaluates each test expression in order, and when a True expression
is found, returns the value specified in result for that expression.
You can include a default result at the end of the parameter list. If none of the expressions
evaluate to True, the Case function returns the value specified for defaultResult. If no
You can include a default result at the end of the parameter list. If none of the expressions
evaluate to True, the Case function returns the value specified for defaultResult. If no
default result is supplied, the Case function returns an “empty” result.
Examples
Case(Score >= 90;“Excellent”;Score > 50;“Satisfactory”;“Needs
Improvement”) displays
Improvement”) displays
Excellent
when the score is 90 or above,
Satisfactory
when
the score is between 50 and 90, and
Needs Improvement
for any other score.
Case(Shipment Method=”Ground”;2;Shipment Method=”Air”;10) returns
10
,
when the Shipment Method field contains Air.
Choose
Format
Choose(test;result0{;result1;result2...})
Parameters
test - Any integer calculation. The calculation result of test must be a number that
into the list that follows. Because the index is a 0 based index, the test result must
be 0 to access the first result.
result - one or more results.
Parameters in curly braces { } are optional.
Parameters in curly braces { } are optional.