end

Type

Procedural Command

Purpose

The end command marks the end of the span of control of other processing and/or procedural commands.

Syntax

 ACTION 1 .

 ACTION 2 .

 .

 .

 ACTION N .

end

Usage

An end command is required following the last specified action invoked by a for, case, if, or while command.

When multiple procedural commands are used in a script, the proper positioning of end commands is critical to correct processing. Each end command refers to the most recent procedural command in the script. Each procedural command controls processing of the script until it reaches its matching end command (see Example 2).

Example 1

for MEMBERS ;

list records

LAST NAME ;

TOTAL DUE .

end

This script tells DataEase: Process all the MEMBERS records and list each member's LAST NAME and TOTAL DUE in the report output.

Example 2

for MEMBERS ;

if highest of RESERVATIONS DATE < 01/01/99 then

delete records

else

delete records in RESERVATIONS

with ( DATE < 01/01/99)

end

if highest of RESERVATIONS DATE >= 01/01/99 then

list records

LAST NAME in order ;

highest of RESERVATIONS DATE .

end

end

This script tells DataEase: (1) For each MEMBERS record, find the most recently dated record in the related RESERVATIONS table, (2) if the most recent reservation is dated before January 1st, 1999, delete the MEMBERS record, (3) if a member's most recent reservation is dated on or after January 1st, 1999, delete all of that member's RESERVATIONS records dated prior to 1999, and (4) for all members with reservations dated on or after January 1st 1999, list the members in order by LAST NAME and show the date of each member's most recent reservation.

Notice that for each if command in the script, there is a corresponding end command. The first end marks the end of the if command that selects which records to delete. The second end marks the end of the if command that selects which records to include in the report output. The third end marks the end of the for command that selects the records from the Primary table.