Hi Barry,
There're a couple of MSKB articles addressing this issue:
-
FIX: Header Corruption Causes END TRANSACTION to Discard Appended Records mskb #
Q293638.
-
INFO: Data Reliability Enhancements in Visual FoxPro 8.0 mskb #
814131.
>I have a scenario in which I am getting header corruption where the file size is incorrect.
>
>This appears to occur when I am issuing updates from within a BEGIN / END TRANSACTION. Unfortunately I do not receive an error.
>I am determining that corruption has occured using this formula:
>HeaderIsOk = ( FileSize - SizeOfHeader = SizeOfRecord * NumberOfRecords )
>
>After running stonefields Repair() function on the table(s) in question it appears that the problem persists.
>
>Subsequently, if I alter the table by adding and then dropping a column, the header appears to be corrected.
>
>I was hoping to be able to trap for the condition, and then warn the user and force them to run stonefield Repair().
>
>Any suggestion would be greatly appreciated.
--sb--