Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Visual FoxPro 5.0 and Indexes not being updated
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00725252
Message ID:
00725536
Vues:
19
How about buying a copy of StoneField?

>Hmmm... Warren said that a REINDEX brings the indexes back in synch.
>
>Now a REINDEX effectively does an internal DELETE TAG ALL and then rebuilds indexes based on the TAG info saved before deleting it.
>Since the index **IS** repaired by the REINDEX, why in the world would the other way provide any better result????
>
>To me there is far too much FUD spead here about REINDEX. I'd bet that 99.9% of the time REINDEX works just fine.
>
>Now, my only guess on this problem by now is that the .CDX inquestion is not a "structural" index, but I freely admit thatit is a VERY long shot indeed.
>
>
>
>>I think Sergey's advice is good. Open Locations.dbf. In the command window, type LIST STATUS TO MyFile.TXT (this is your list of associated TAGS and their KEYs. Then [for each tag], DELETE TAG MyTag. Then Index (not reindex) each tag according to the KEY specifications in MyFile.TXT.
>>HTH
>>>All indexes are CDX's as the table name like location.dbf and location.cdx.
ICQ 10556 (ya), 254117
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform