Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Visual FoxPro 5.0 and Indexes not being updated
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00725252
Message ID:
00725536
Views:
14
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
Previous
Reply
Map
View

Click here to load this message in the networking platform