>Hi Bruce,
>
>I'm thinking this was your 'theory of lost data' or something like that that you are referring to. Is that correct?
>
>If so, I don't remember how you solved it.
>
>But in the context of this problem how would you rate this idea. . . SET REFRESH???
Yes, that was my theory :) And I'm quite sure it's a true one. Sometimes, I think only with EXCL on, vfp will copy a table (if it fits) to the local machine, and perform all its work there, I think even including commands like FLUSH and SET REFRESH, and certainly TABLEUPDATE.
My solution was to close and reopen the pertinent tables at specific points, particluarly after some statistical processing was done, there is no question that will push data to server. Also, I reopened SHARED where possible, since...
I'm not positive about SHARED tables - but I'm inclined to think this will not occur in that more typical multi-user case, else we would have heard a lot more about it by now. My EXCL usage in a multi-user environment is a little unusual, and many of my tables are large enough so that they won't fit on a local machine anyway, another reason we haven't had this problem appear before...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.