General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only