Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Eric,
I already deleted the dcx and when I opened the dbc, VFP recreated a dcx. Is this as good as your suggestion? Can I trust the index that was created automatically or should I create it manually by your method? By the way, how can I view the index to check it?
Thanks for your help
Allen
>>I get an error when trying to open my dbc that the index does not match the table. It tells me to delete the index file and re-create the index.
>>My question is how do I do this properly? I'd hate to delete my .dcx and then be screwed. How do I re-index a dbc? Can someone confirm the procedure so I get my database back? Thanks in advance.
>>Allen
>
>Luckily, A dbc only has a couple of indexes to begin with. YOu probably should avoid REINDEX, because the info in hte header could be corrupt and you could just get another funky index. Make a backup of your dbc and do issue the following:
>
>USE MyDBC.dbc EXCL
>DELETE TAG ALL
>INDEX ON STR(parentid)+objecttype+LOWER(objectname) TAG ObjectName
>INDEX ON STR(parentid)+objecttype TAG ObjectType
>
>And that should do it.
Précédent
Suivant
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