Mark,
You're absolutely right.
BTW, I beleive SCAN runs more faster than DO WHILE !EOF()
>Why is this in a loop? Each UPDATE does a full table scan or at least updates all matching records if optimized with indexes.
>
If it's not broken, fix it until it is.
My Blog