IIF

This will return either the true_val or the false_val depending on the outcome of the argument expression.

Try not to use this if the true or false values contain any UDB commands as they will both be evaluated regardless of the outcome of the argument and this will waste resources.

Number	Name	Default	Type	Description
1	argument	FALSE	String	The argument to evaluate
2	true_val		String	The value to return if the argument result is TRUE
3	false_val		String	The value to return if the argument result is FALSE

{VAR(V_EXAMPLE, 1)}

{IIF( {V_EXAMPLE} = 1, <p class="text-success">TRUE</p>, <p class="text-warning">FALSE</p> )}
{IIF( {V_EXAMPLE} = 2, <p class="text-success">TRUE</p>, <p class="text-warning">FALSE</p> )}

TRUE

FALSE

Embedded Inline IF Statement Example

You can also include an inline IF statement in an inline IF statement

Code
Result

{VAR(V_NUMBER_1, 5)}

{IIF( {V_NUMBER_1} > 0, <p class="text-success">POSITIVE NUMBER</p>, {IIF( {V_NUMBER_1} < 0, <p class="text-warning">NAGATIVE NUMBER</p>, 0)} )}

POSITIVE NUMBER

to add a Comment.

IF Commands

COMPARE
ELSE
ELSE_IF
EMPTY
IF
TOT_IF

ULTIMATE DATABASE

HIGH QUALITY BESPOKE SOFTWARE DEVELOPMENT TOOL

IIF

Basic Example

Embedded Inline IF Statement Example

IF Commands