>Hi,
>
>I've been having problems with an index getting messed up when issuing a TableUpdate. The problem happens on an ordered table using optimistic row buffering. When there is a conflict I just want to force the last change. The force messes up the index (phantom record.) A Reindex fixes it. The code below will duplicate the problem. (At least with VFP5) Any ideas?
>


Wow, that's a trip. I get the same behavior in VFP6 SP3. I would venture to say that this qualifies as a bug.

My testing shows that this only occurs when you use Row buffering to commit your updates. If you issue an explicit TABLEUPDATE(), it doesn't happen. This fact should get you around the problem.

As an aside, I never, ever use Row buffering because of its unpredictability and inflexibility. I just can't think of a reason that you want to let VFP commit your updates for you without you asking.