Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement