Hi,

I have a base-table with approximately 100.000 records I have to loop through. This table (toguether with 2 other tables) is the basis of an export table I want to fill.

If I just use a collection and loop through this base-table, the process quits after +/- 9000 records. So, I think I have to loop through smaller parts of the collection using the limit and offset feature. 

Can anyone explain how to do this without processing the same base-record several times?

Corné