Simplicty and flexibility!


Support::

Nested Actions


Parameters


Returns/Result


Examples


Reference

Nested Actions

Nested Actions

Type

Concept

Purpose

A Nested Action is an action that is invoked by another action.

There are two types of nested actions: (1) A nested loop action performs the same series of actions on each record that is processed (see Example 1), and (2) a nested conditional action is most often used to select subgroups of records and perform different actions on each group (see Example 2).

Example 1

for MEMBERS ;

for RESERVATIONS

list records

MEMBERS LASTNAME in groups ;

RESERVATION ID ;

TOTAL DUE .

end

end

 

This script tells DataEase to perform the same series of actions on each record selected by the for command. In this example, the second for command, which retrieves the RESERVATIONS records related to the MEMBERS record that is currently being processed, is nested within the first for command.

Although DataEase does not require it, it is easier to follow the logic if you indent nested actions as shown in these examples.

Example 2

for RESERVATIONS ;

if TOTAL DUE > 2000 then

modify records in MEMBERS

STATUS := PREFERRED .

if DATE between 01/01/99 to current date then

enter a record in CATALOG MEMBERS

copy all from MEMBERS .

end

end

end

 

This script tells DataEase to select two groups of RESERVATIONS records: (1)All the records with an TOTAL DUE greater than $2000 (the related MEMBERS records get modified), and (2) the records with an TOTAL DUE greater than $2000 and a DATE between the start of 1994 and today's date (the related MEMBERS records get modified and copied into the CATALOG MEMBERS table).

In this example, the second if command, which selects a subgroup of the records selected by the first if command, is nested within the first if command.

See Also


On the forum about Nested Actions

[@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. 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 Nested Actions


dg3_HelpView