>I am writing a search and replace function.
>
>If I search and replace in a field which is part of the current index tag I can miss fields to modify since the index order well be changing as I make changes. That is if I am changing #4 to #5 I can miss the rest of the #4's.
>
>I seem to remember that there is a way to supress updates to the index until I have passed thru the table.
>
>I know this is not a problem when I am changing the entire table, I just turn off the index and scan the entire table. However I now have a request to allow changes from the current record to the end, based on the current order.
You can't suppress the indeces from being updated. Try this code:
SEEK SomeValue
DO WHILE FOUND()
REPLACE SomeField WITH SomeValue
SEEK SomeValue
ENDDO
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer