For to loop not working

pauldamen — Fri, 29 Dec 2017 11:01:38 GMT

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

Re: For to loop not working

sunny_talwar — Fri, 29 Dec 2017 12:47:59 GMT

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');

topic Re: For to loop not working in App Development

For to loop not working

Re: For to loop not working