Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Supress Index Updating
Message
De
08/09/2000 19:36:20
 
 
À
08/09/2000 15:35:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00414381
Message ID:
00414493
Vues:
18
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform