Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi John.
>I just found out to my supprise that I can't directly read the info in a DBC.
You can using DBGETPROP().
>The more pressing thing is I need to create a program to index-reindex all my tables.
That's a different matter -- the DBC doesn't have any of the information necessary to create indexes, since it doesn't store the index expression, filter expression, ascending/descending, or collate sequence.
If you want to save yourself at least 80 hours to create a generic routine that will recreate indexes (I know, because this is how long it took me to write that routine alone), take a look at Stonefield Database Toolkit (SDT). In addition, to recreating indexes with a single method call, it can also repair corrupted table and memo header and update table structures at your client sites. PUTM members get a 10% discount on SDT.
Doug
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement