Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rebuiding Indexes
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00043992
Message ID:
00044042
Views:
29
>>>I'm getting ready to rewrite the re-indexing routine of a large VFP 3.0 application. The old routine does not delete the .CDX files. It uses ALTER TABLE to drop the a table's primary key, then creates the primary key and other indexes (including foreign keys), then creates the table's triggers. After doing this for all tables, it (re)creates the database's RI.
>>>
>>>I remember an earlier posting (Barbara P.?) about deleting the .CDX files first, but didn't save the message and can't find it in my searches(I'm a basic member). Seems it was better than rebuilding the file.
>>>
>>>Does anyone have comments/suggestions?
>>
>>i think there was a detailed rundown of these steps in one of the articles in the knowledgebase here (red dice)
>
>Thanks, Dave. I checked the KB articles but didn't find anything on programaticy rebuilding CDX files. Did find several other usefull items, however.

must have been the vfug newsletter then.

VFUG
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform