Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
User Loses Data
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00253988
Message ID:
00254117
Views:
17
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform