Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INDEX problem
Message
From
07/09/1997 23:35:03
Larry Long
ProgRes (Programming Resources)
Georgia, United States
 
 
To
05/09/1997 17:49:46
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00047222
Message ID:
00048915
Views:
23
>>When this append, some or all CDX (index) are corrupted. I try the VALIDATE DATABASE command, some times with the RECOVER option, I try to REINDEX, but I can’t recover all. I can't beleave I have to do a program to manage this. I realy need help on this, because I am losing a lot of time to recover the data.
>
>Stonefield Database Toolkit (SDT) provides this and many other capabilities. SDT will recreate corrupted indexes, repair corrupted table and memo headers, update the structures of tables at remote site without custom programming, and allows you to define new extended properties for database objects (such as field level security).
>
>For more information on SDT and other Stonefield products, check out our Web site at www.stonefield.com.
>
>Doug
Once you get a corrupted index NEVER "just reindex". I always

DELETE TAG ALL
ERASE index.cdx

then rebuild the index from scratch. I always have a program call REINDX.PRG that has my index structures in it. So when there is corruption, I just call the REINDX program. The problem that you may be having is that the index's header information may be corrupted and a REINDEX does not correct or re-create an index's header.

Hope this helps //:^)
Larry
L.A.Long
ProgRes
lalong1@charter.net
Previous
Reply
Map
View

Click here to load this message in the networking platform