# 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:

![](/files/-MAlQBZuuTnc6hyzKSVQ)

### 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       |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://doc.sysdevmobile.com/kalipso5/developing/form/actions/actions-description/group-code-flow/while...end-while.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.