How to Define Decisions

Previous Next

See Also

Decisions are defined in the Definer, and "assigned" to (behavior) properties in the Windows Designer.

To define a decision:

1. From the menu bar in the Definer, choose Define, Decisions.

The Decisions window appears.

2. Supply the name of the decision.
3. Do not use the Client Path attribute. This attribute is supported for backward compatibility only.
4. Specify the Decision SQL statement.

At this point you can specify a fully SELECT statement that retrieves data from the database, or a SQL (WHERE) condition that validates on-screen data. For more help, refer to the "Decisions" help topic.

5. Specify the action to take if the condition is met (`Yes Action). Do this by opening the Object Activator as a stand-alone editor.

In Yes Actions, you can refer to data retrieved by the Decision SQL by using :1, :2 etc. placeholders.

6. Likewise, specify the action to take if the condition is NOT met (No Action).

In No Actions, you cannot refer to data retrieved by the Decision SQL.

7. From the menu bar, choose Record, Store Row.
8. To have the SQL of your decision checked for syntactical correctness, click the Check button.
9. Click OK to confirm any messages, correct any errors if necessary, and then save your changes.