Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Supress Index Updating
Message
From
08/09/2000 19:36:20
 
 
To
08/09/2000 15:35:13
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00414381
Message ID:
00414493
Views:
17
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform