General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Rich.
>I have a client that had a power outage yesterday on a Novell server and it corrupted a SCHEDULE.DBF table's memo file. No problem I rebuilt that. However, I have BIZZARE problem that has occurred. The user saves an Invoice entry that is wrapped in a Transaction and the Save processes without any errors.
I've encountered this problem before, and Microsoft is aware of it. It's caused by an invalid record count in the table header. VFP doesn't complain when the table is opened, and saves appear to work, but in fact what happens is that the records always overwrite the last record in the table and are never appended.
The solution is to repair the table header by replacing the record count with a valid value. Stonefield Database Toolkit can correct this, of course, but even something as simple as COPY TO should correct the problem (that's why PACK fixed it in your case).
Doug
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only