Purpose:
Allows to define conditions. The first parameter is a logical expression that will be evaluated as "True” of "False”. If the first expression is "True”, the second expression will be returned as the result. If the expression is "False”, the third expression will be returned as the result. If no third expression is entered, the return value will assume the following standard values, dependent upon its type:
|
2. Argument Type |
Return value if expression = False |
|
Boolean |
False |
|
String |
"" (empty String) |
|
Date |
Julian Date value 0 |
|
Number |
0 |
|
Picture |
"" (empty String) |
|
Barcode |
"" (empty String) |
Parameter:
Boolean
All
All (optional) The third parameter must be the same type as the second parameter.
Return value:
All
Example:
Cond(COUNTRY<>"USA",COUNTRY_LONG)
Cond(PRICE=0,"on request",Str$(PRICE,0,2))
Cond(empty(COMPANY),SALUTATION,COMPANY)