>>>When re-indexing data files, I first delete the CDX if it exists then recreate. I do
>>> things this way, as, over the years I have had some customers lose their CDX
>>>file/s.
>>Before you delete the cdx, use the dbf exclusive and issue DELETE TAG ALL
>
>Actually, DELETE TAG ALL does delete the CDX, so this is redundant.... Just remember, if you're doing this to a table in a database, you'll lose any permanent relations you have set....
I add the DELETE TAG ALL and the DELETE FILE commands just to make sure that the CDX file is deleted. Sometimes (although rarely) your dbf can lose the connection to the CDX.( For example if the dbf was copied without the PROD parameter)