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.