image\Dql_0024.gifbreak

Type

Procedural Command

Purpose

The break command is used to immediately stop the action of a for or while command and continue processing the rest of the procedure.

When processing reaches a break command, DataEase immediately abandons the current action. It resumes processing the procedure with the first action listed after the corresponding end command.

Syntax

 ACTION 1 .

 ACTION 2 .

 ACTION 3 .

 break .

end

NEXT COMMAND

 

Usage

The break command is always followed by a period.

Example

for MEMBERS ;

list records

TOTAL DUE in reverse ;

LAST NAME .

if current item number > 100 then

break .

end

end

for RESERVATIONS ;

delete records with DATE < 01/01/90 .

end

 

This script tells DataEase: (1) List each member's TOTAL DUE and LAST NAME, arranging the output from highest to lowest TOTALDUE value, and (2) when one hundred MEMBERS records have been processed, stop listing records and proceed to the next command (delete RESERVATIONS records with DATE before January 1, 1990).