Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Corrupted or Locked Table
Message
De
12/01/2001 11:52:17
 
 
À
11/01/2001 17:36:40
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00462627
Message ID:
00463036
Vues:
15
Hi Stacy.

>problem: table will not accept new records
>
>fix: copy table to another location
> zap and pack the table
> append records from the copied table

This is a known problem with VFP. As Chris pointed out, the record count is the header is incorrect, so new records aren't properly appended to the end of the table (often, they overwrite the last record so while they're added initially, they're overwritten when you add the next record). TABLEUPDATE() returns .T. so you can't detect this error that way, unfortunately. The fix you outlined works, as does running SDT's Repair method or even Reindex with the pack parameter set to .T., because in essence the table header is rebuilt with a corrected record count.

Doug
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform