While...End While

Kalipso - Form - Actions - Actions Description - Group Code - While...End While

A while loop is a control flow statement that allows code to be executed repeatedly based on a given condition.

Action available for the following operating systems:

Parameters

• Condition <unquoted string> - This parameter is the condition that is verified in iteration of while loop. This condition may be a complex expression with AND and OR operators like in the common programming languages.

Usage

Consider the following database table "Products":

Code	Name	Stock
001	Coca Cola	100
002	Pepsi Cola	200
003	Pork Chops	300

Example 1

Set Value(VAR(0),Numeric,0)
Set Value(VAR(1),Numeric,001)

While(VAR(0) <= 1)

SQL Statement(Delete; Products; FIELD(Products, Code)=VAR(1))
Set Value(VAR(1), Numeric, VAR(1)+1)
Set Value(VAR(0), Numeric, VAR(0)+1)

End While

Result:

Code	Name	Stock
003	Pork Chops	300

Example 2

Set Value(VAR(0),Numeric,0)
Set Value(VAR(1),Numeric,004)

While(VAR(0) < 3)

SQL Statement(Insert; Products; No; Yes; Code=VAR(1); Name="Product " + VAR(0); Stock=100)

Set Value(VAR(1), Numeric, VAR(1)+1)
Set Value(VAR(0), Numeric, VAR(0)+1)

End While

Result:

Code	Name	Stock
001	Coca Cola	100
002	Pepsi Cola	200
003	Pork Chops	300
004	Product 1	100
005	Product 2	100
006	Product 3	100