I have one SCAN Loop going. I am adding data from the main WORK.DBF file to a file called BATCHN.DBF. At the end of the loop (ENDSCAN), the WORK.DBF file is reselected, and it shows that we are on the 2nd recor, which is great. However, once I select the BACTHN.DBF table, the record in WORK jumps back to the previous record we were on in the WORK table.
I have not placed any GO TOP command in this code. I cannot figure out why the record in WORK on its second pass doesn't stay on the 2nd record, but goes back to the top or the previous record (same thing).
The SCAN LOOP has no conditions.
Any ideas?