I see your point, but since I've known about USE AGAIN, I hardly every save/remove/replace the order on the table to change to another order. I just USE AGAIN IN 0 [ORDER NewOrder] ALIAS NewAlias, do stuff, then USE IN NewAlias.
Rich.
>I too had never before seen a FOR Counter=1 TO RECCOUNT() loop. There is on way this may be more useful than SCAN..ENDSCAN. If you wanted the loop to proceed through the table (cursor) in record number order without having to remove the ordering of the table before the loop and reattach that ordering after the loop.
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing