Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Stopping Re-ordering of Index File During Update
Message
 
 
À
18/09/2003 19:57:15
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00830509
Message ID:
00830516
Vues:
30
>sergey,
>
>I would like to follow your suggestion but the table in quetsion is very large and I have a program that is seeking groups of records indexed by a particular value in the index field - if i do a search in physical order rather than in index order the process will take 10 times longer, which is why I was looking for a means to stop the table index being updated until the whole process is finished.

If Exclusive Use is not a problem, then: have you considered Setting the desired order and then copying the entire table (in order) to a new table (perhaps with production), then you can process the new table in natural order which happens to now coincide with your desired order. You will still need to use an xBase SCAN to locate the next record to process.

Alternatively before processing, select all of the Primary Key details and RecNo()'s of the affected records before starting the process. Set Order To 0, iterate through your selection, and when you Goto a record to change it, you can use the PK to verify that it has not moved.
censored.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform