Contents
Display Legacy Contents

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

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.

     
Consider the following database table "Products":

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

Example 1

Example 2
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

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

     
 

    See also
    Samples

     
     
    Updated: 3/21/2018 5:49 PM