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)