Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with GenDBCX
Message
De
28/12/1999 14:47:11
 
 
À
28/12/1999 14:08:30
Nancy Folsom
Pixel Dust Industries
Washington, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00309332
Message ID:
00309395
Vues:
29
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform