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.
Barry Taft
i am only worried in the short term. once there is a problem, the solution usually presents itself.