Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
I am trying to create a for loop which partially looks like this:
let vAantal1 = sum(num(Aantal));
LIB CONNECT TO xxxxx;
set Counter = 0;
for Counter = 0 to $(vAantal)
The field Aantal is coming from a previous loaded table and contains the total number of records in the table. The second loop should load all the details in a loop which runs from 0 to the total number of records. But it keeps giving me the following error:
The following error occured:
for Counter = 0 to >>>>>><<<<<<
Any thoughts?
Regards, Paul
I think this is the part which is a problem
You can't really use Sum/Min/Max in your variable directly... may be you can do like this
Sum:
LOAD Sum(Aantal) as SumAantal
Resident ....;
LET vAantal1 = Peek('SumAantal');