Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Corrupt table
Message
From
16/10/2002 19:59:56
 
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00709049
Message ID:
00712091
Views:
9
Rich,
>
>I've been burned by the corrupted Header info by records not getting posted and at the same time not getting an Error while in a BEGIN TRANSACTION END TRANSCATION. In fact, I had to dial into a client while at DEVCON in the middle of the night to patch my client's data. I did test this with VFP 8 and it correctly detects the problem during the USE of the table. However, this DOES NOT solve my problem when multiple users have the table open at the same time and one of them reboots their system for whatever reason instead of backing out of a Transaction and the HEADER becomes corrupted.
>
The work around I use is to append any new records, add the primary keys and save them to disk as a first begin/end transaction. I then reseek these new records, and if the seek is not successful, that is evidence of the corruption, and one can then abandon the main transaction.

I was hoping to be able to omit this extra processing in VFP8, but my guess is that I won't.

Geoff
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform