with

Type

Operator

Purpose

The with operator specifies the criteria for selecting records in a table or a relationship.

Syntax

with ( SELECTION CRITERIA)

Usage

The with operator tells DataEase to process some rather than all the records in the specified table. The records that are selected for processing are those that satisfy the selection criteria that follow the with operator.

Example 1

for MEMBERS with TOTAL DUE > 150 ;

This statement tells DataEase to process only those MEMBERS records that contain a value greater than $150 in the TOTAL DUE field.

Example 2

delete records in RESERVATIONS named "OUTDATED"

 with ( DATE < 01/01/99) .

This statement tells DataEase to delete the records in the "OUTDATED" relationship (the RESERVATIONS records that are dated before 01/01/1999).