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