Define "finer nuances" ...
SCAN...ENDSCAN simply goes record by record through a table without an explicit record pointer command like SKIP. You can enhance the flexibility of SCAN..ENDSCAN by adding a FOR clause to only skip through records matching the clause or a WHILE clause where the SCAN will end at the first record not matching the WHILE clause.
>Can anyone refer me to an authoritative and thorough resource for the many uses for this command? I work with data conversions/translations and use this command daily, but still don't grasp the finer nuances. Any help would be greatly appreciated!
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05