>>>>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

Dave,

Sorry to take so long to respond. I had already left the UT for the VFUG and found the article in the March '97 newsletter. Thanks for you assistance.