Cond

combit List & Label Designer

combit List & Label

Cond

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)