ULTIMATE DATABASE
HIGH QUALITY BESPOKE SOFTWARE DEVELOPMENT TOOL
Feature Rich
Rapid Application Development
Helping you or your customers
Manage their Business

All Commands All Program Flow
Commands

FOR_LOOP

This provides a loop of values, dates or times and places the value in the specified variable.

You can use the {LOOP_COUNT} command to return the current iteration.

This command requires an {END_FOR_LOOP} command.

Number Name Default Type Description
1 type integer String

This indicates the type of loop. It can have any of the following values:

  • integer or int
  • numeric or num
  • alpha
  • date

You can also abbreviate them to int, num, alp or dat
2 var V_LOOP String The name of the variable to use for the changing value.
3 first 1 or A or today's date depending on the type String This is the first value in the loop.
If you are specifying the first date then the format YYYY-MM-DD or YYYY-MM-DD hh:mm:ss is required.
4 last 1 or Z or today's date plus 10 days depending on the type String This is the last value in the loop.
If you are specifying the last date then the format YYYY-MM-DD or YYYY-MM-DD hh:mm:ss is required.
5 step 1 or 1 day depending on the type String

This indicates the step.
For the integer type, an integer is expected
For the numeric type, a numeric value such as 1.2
For the alpha type, this is forced to 1
For the date type, a duration is expected such as "1 day" or "2 weeks"

Negative values are allowed but the first value should be greater than the last.
Alphanumeric Example Example
A : B : C : D : E : F : G : H : I : J : K : L : M : N : O : P : Q : R : S : T : U : V : W : X : Y : Z
Date Example
January 2020
February 2020
March 2020
April 2020
May 2020
June 2020
July 2020
August 2020
September 2020
October 2020
November 2020
December 2020
Integer Example
0:1
1:2
2:4
3:8
4:16
5:32
to add a Comment.
LOOP Commands
API_DATA
API_FOR_EACH
ARRAY_FOR_EACH
CSV_FOR_EACH
FOR_EACH
LOOP_COUNT
SEQN
WHILE