Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stopping Re-ordering of Index File During Update
Message
 
 
To
18/09/2003 19:57:15
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00830509
Message ID:
00830516
Views:
33
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform