Let's say I have a table of 50 records.
How can I find the first 10 records. Then next 10 records. and so on?
What criteria makes them first?
You can pull up a found set of records, sort or unsort them, then use omit multiple records to omit all but the first 10 or omit the first 10, then omit all but the next 10.
the number of records the you omit can be calculated.
Get (foundcount) will tell you how many records are in your found set.
Get(recordnumber) will tell you which record in the found set is the current record
If you use omit multiple records and specify a number larger than the number of records from the current record to the end of the found set, your script will omit all records from the current record to the end of the found set.
Can you explain what you'd like to do with these groups of 10? Display 10 at a time? Print? Something else?
I want to export them in separate files.
Retrieving data ...