Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Quickest Way to Check for Invalid Reccount in Table Head
Message
De
10/02/2002 17:12:05
 
 
À
09/02/2002 22:08:19
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00616383
Message ID:
00618100
Vues:
27
Calvin,

I haven't seen this scenario, but given the corruption occurs, no further cchanges take place in the table. If there is additional data, yes, it ought to be recoverable. It does not really surprise me that Reindex does not fix the problem, A reindex in VFP does not do a pack, either. Have you tried just using the active reindex? Does it do the same thing?

You could, of course, check the header before calling SDT's Reindex, or patch the check into SDT itself.

Geoff

>I don't know if this is a possibility in VFP, but I had a test table with 100 records and I set the reccount to 7 and when I reindexed in SDT with the pack flag set I only had 7 records left whereas if did repair the entire table was recovered. I have seen situations in FoxPro where the reccounter would only contain a fraction of the actual number of records in the table so I suppose it is possible in VFP. I do not believe that SDT's reindex function should do this to a user.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform