Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BUG? TableUpdate is TRUE but no records written.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00365567
Message ID:
00366172
Vues:
13
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
Fil
Voir

Click here to load this message in the networking platform