>
>Hmm, it might. If you're updating the field the SCAN is using, it probably will change the order. Later on you might be processing the same records again. You could do a SELECT into an array (I think someone else suggested this), or do a SELECT into a cursor and SCAN the cursor. That way, no updating would impact the SCAN.
Hi Fred. Yes this is what I did. Thanks.
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.