Conditional Dialog

Top 

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.

Statement

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

Information

Describes the currently selected component in the Statements box.

Check

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.

Accept

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

Structure

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

Operators

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

Data

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

Functions

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

User

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

IF THEN

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

CASE OF

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

Delete

Deletes the selected statement from the conditional structure.

See Also:

How to Create a Simple Assignment Expression

How to Create a Complex Assignment Expression