Predicate Tab

Working with Database Operations > Using the Database Operation File Editor > Predicate Tab

	Predicate Tab

Use the Predicate tab to set the conditions that determine which records are operated on. For example, suppose you want the database operation to query the database and return all records for customers who are delinquent in their payments. You can use the Predicate tab to set the conditions and instruct the database which records to return.

Note:

The Predicate tab appears and is used only with Delete, Query, and Update operations.

Compound conditions can be created within the Predicate tab. These conditions are used for nesting two conditions (Simple, Join, or Compound) that are joined by a Boolean operator. In addition, compound conditions can be nested to build complex Where clauses. See the following example for better understanding.

See example in Setting Conditions for a Compound Database Operation.