>Claudio-
>
>
>
>I have been looking for some routine to reconstruct indexes, and founded Steve Arnott's GenDBCX. Reading his documentation, I guess that is a great utility, and I'm trying to use it, but I'm having some problems.
>>
>>What I did? I've deleted some CDX files (to simulate a lost of it), and executed the method CreateIndices, for the program recreate my indexes. No way: it shows me some errors message, such 'Primary Key already exists', 'CDX structure not find', etc...>
>I may misunderstand you, but if you are simply executing the generated PRG then you are doing too much if all you want is to recreate the indices. The PRG that gendbcx (or gendbc, for that matter) will recreate your entire database. Instead, look at the prg and pullout the sections you need.
Nancy- genDBCX creates separate methods for recreating indeces, so there is really nothing to pull out.
Claudio- you are getting this error because you did not destroy the indexes correctly- you need to issue DELETE TAG ALL on the table, to let the table know that you are killing all the tags. Otherwise, the dbf itself thinks it is still tied to an index file.
Erik Moore
Clientelligence