On Clause
Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.
- (
- Select one left paren or a set or parentheses to group your call qualification components. Be sure to select the appropriate right parentheses in the
) column to complete your group.
- Fn()
- Select a function on which to qualify the call.
- Column
- Shows the relevant column for the call.
- Operator
- Select an arithmetic operator to create an equation between the column in the
Column field and the value in the
Value/Subselect field.
- Value/Subselect
- Select a field from the list, type a literal value, or select SUBSELECT to set the value for the qualification.
- Boolean
- Select
AND,
OR, or nothing as your boolean operator.
- Apply
- Click this to save the current assignments.
- Reset
- Click this to cancel the assignments made.
- Add/Del Fields
- Click this to add or delete fields from your database call.
- )
- Select one right paren or a set of parentheses to group your call qualification components with the appropriate left parentheses selected.
