I have been trying to stay away from FoxPro 2.6 but I am still in it about once or twice a week.
Question are you running this on a Novell server?
This problem is more common to Novell than NT but it may be in both!
If you are getting corrupt Indexes it is from "Append From" and "Delete For" Commands.
What I have done to work around this is to go through all my code and use Scan For; Endscan or some other kind of loop to Delete or append what ever.
I have done the same thing you did to fix the problem
I delete the Indexes, Copy the table to a new Temp file Delete the old one, then sort it by the key field back into the original name (just to give it more speed) and rebuild my indexes.
Hope this helps
Mike Baty
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only