Hi Eric,
AFAIK there is no reliable way to detect an index corruption therefor how can you avoid someting you/your program don't know about.
Your idea about a field called locked has the same flow because it requres a record modification.
Unfortunally I down't have solution for this problem. Maybe somebody else would jump in.
>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
--sb--