>Hi Bruce.
>
>>One of my users reported that he had spent an hour or so editing on different pages and forms, when the machine locked up, and he apparently just rebooted. All his edits were missing from the server data, although there was no other problem with the data. He was quite upset, as we all are when we lose our work.
>
>The only time I've seen this happen is with a corrupted table header. If the record count is bad, VFP simply overwrites the last record in the table rather than adding a new one. Thus, only the last record the user entered appears to be there. The interesting thing is that TABLEUPDATE() returns .T. so it looked like it succeeded.
Hmmm....hadn't thought of that, but there are 3 tables that all get updated at the same time, and all are missing the session updates. Just browsed them again, and all appear okay, the user went back in (grumbling, no doubt :) and re-edited his lost work. So I don't think that's the problem...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.