export 100 records at a time

[cheynooki]

Hi there folks ... I'm using FMPro5 and have run into a bit of trouble now that my DB is growing quite large. My site is hosted on a remote server and when attempting to upload the full flat file ... the server will time out before completion. Therefore, I have resorted to "chunking" my exports into a few flat files ... The trick comes when I export to flat file ... I would like it to "grab the first 100 records" ... "create a flat file" ... the "grab the next 100" ... "create flat file" ... so on and so on. I have tried many different sorting options, but have been unable to get this to work out. Is there a way to do this through a script ... am I missing it ... any help would be greatly appreciated. Thanks in advance .... -George-

[Vaughan]

Add a serial number to each record, 1 to x. Perform a find based on the serial number.