Conditional Dialog


A conditional field is a computed field with multiple possible expressions. There are two types of conditional fields--IF structures and CASE structures. The assignment statement executed depends on the evaluation of the IF or CASE condition. For example, an IF structure conditional field called Tax could be 0 if Taxable is FALSE, or Price times TaxRate if Taxable is TRUE.

The Formula Editor allows you to create a conditional expression whose result can then be assigned to a variable. Name your conditional formula in the Formula Editor dialog, then press the Conditionals button to open this dialog.

Each portion of the expression is edited separately. The components appear in the Structure list in the lower portion of the dialog box. Select a component, then edit it in the Statement box. You can add and/or nest IF and CASE structures by pressing the IF THEN and CASE OF buttons.


A currently selected component (displayed in the Structure list) of the actual expression under construction.


Describes the currently selected component in the Statements box.


Tests and validates currently selected component of the expression under construction. A check box appears if it is syntactically correct. An "X" appears if not.


Adds the currently selected component of the expression to the Structure list.


Lists the components of the expression in a hierarchical list. Each item selected can be edited separately.


Provides buttons for inserting logical and bitwise operators into the expression. You can also type them in directly.


Accesses the Select Column dialog, where you can select or define a variable or field as an operand within the expression.


Access a list of built-in Clarion functions in the Functions dialog.


Accesses user defined functions within the application under development, displaying them in the User Function dialog.


Adds and/or nests an IF THEN structure to the expression.


Adds and/or nests a CASE OF structure to the expression.


Deletes the selected statement from the conditional structure.

See Also:

How to Create a Simple Assignment Expression

How to Create a Complex Assignment Expression