>Hi All
>
>I have a table and for each record I want to execute a process and then store the datetime when the process for that record was completed.
>
>I also want to process the records in this same datetime order so that I can loop through all records and process each from the oldest record on file to the most current. So there is an index on that datetime field and which is set as the index to use for dropping through the file.
>
>Of course as soon as I update the first record with the current datetime it moves to the end of the index and the subsequent SKIP positions me at EOF.
>
>I cannot GO TOP since that would put the app in an endless loop. I want to process all the records once, from oldest update to latest udpate.
>
>I can store the update datetime into a second field and then go back over all records when the entire file is done and update the index datetime field with this second field but that would mean that a second instance of my app would not know the correct record to process next <g>
>
>Anybody had a similar situation with an elegant solution?
>
>Thanks
Jos,
Think this may work
Before processing, you use the table order DateTimeField and store the recno() somewhere
Before processing a record, save the record's datetime. Then process it and do a seek() with the saved datetime (to reposition)
You continue processing as long as the recno() )is not equal to the one you saved before processing
Gregory