Simplicty and flexibility!


Support::

Break


Parameters


Returns/Result


Examples


Reference

break

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).

See Also


On the forum about Break

[@EOF@]...

Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32

Hi there,I am trying to use an external MySQL DB in dataease. I have successfully create the ODBC link and added the DB to dataease. I can also access the DB from dataease. Now, just for testing purposes, I am trying to create a simple report b...

Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17

no se pude exportar ahora archivos a pdf, ni a excel o otros cosa mala. en verdad creo que hace faltaen las versiones anteriores me funcionaba mas o menos bien.&nbsp;le hace falta a los aplicativos que se desarrollan en Dataeasegr...

Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11

Thanks. Anyway I'm trying to use this fuction but it seems to me that it doesn't work on 8.2. I tried also in a DQL.There's something wrong?<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA9IAAAJ3CAYAAAB4NWk3AAAAAXNSR0IArs4...

Product: . Written by Marco Marchesi 15/02/16 at 14:50:46

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46

Thanks for the very good explanation!AS...

Product: . Written by afonso santos 28/10/19 at 00:50:14

I am pleased to see that the migration from Dos 4.53 is then sa 5.5 works. A really useful thing would be a compiler of SQL languages. Will you get there?Original Text:Mi compiaccio a vedere che la migrazione da Dos 4.53 è poi sa 5.5 funzio...

Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44

How can i delete a Style sheet?...

Product: Dataease [{8}]FIVE. Written by Rainer 22/03/21 at 11:13:10

I run W7 and since a few days&nbsp;Dataease 8.5 is not starting any more, do you have an idea? i installed it again but that did not help....

Product: Dataease [{8}]FIVE. Written by Rainer 08/06/21 at 14:12:40

[@EOF@]...

Product: . Written by Hiralal Rampul 01/12/21 at 17:47:10

On the blog about Break


dg3_HelpView