Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to avoid writing when index is corrupted ?
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to avoid writing when index is corrupted ?
Miscellaneous
Thread ID:
00530308
Message ID:
00530308
Views:
66
It happened to me a few time that an index was corrupted and vfp was writing in a bad record. As you can imagine, it is very scary in term of reliability and integrity. Is there a way to avoid this ?
I was thinking about a solution that would at least cover a some situations:
When a record should not be modified, we use a field called locked (.t./.f.) and put it as true. If we put a trigger on the database, maybe we can make sure that, at least, the record we want to update can be modified.
But maybe there is a better solution ?

Thanks
Eric
Eric Crespin
Consultant
PC PLUS Software Inc.
www.pcplus.ca
Next
Reply
Map
View

Click here to load this message in the networking platform