Are you sure about this Jim? From the Hackers' Guide: "... processing starts with the first record in the current order". I've tested it and the SCAN did start at the first record in the current order.

---

>SCAN begins from the current record unless you tell it differently. Your code opens the table with the record pointer on the first record. It then changes the order of the records so the current one is the last one. Then you SCAN and it will only see the one record because the next skip at endscan will move to EOF().