christer102
IS-IT--Management
How do I reindex DBASE III/IV specific table from a command prompt?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
REINDEX DBASE III/IV 1
- Thread starter christer102
- Start date
- Status
-
1
- #4
JCreamerII
MIS
christer102,
You will be better off if you erase the old index file name & recreate the new index from scratch, using the "INDEX ON" command. If you have corruption in the header then reindex will propagate the corruption into the header in the new index. "INDEX ON" recreates it from scratch and should always be a clean index.
Jim C.
You will be better off if you erase the old index file name & recreate the new index from scratch, using the "INDEX ON" command. If you have corruption in the header then reindex will propagate the corruption into the header in the new index. "INDEX ON" recreates it from scratch and should always be a clean index.
Jim C.
Are you asking about an independent index (.NDX) or compound or master index file (.MDX)? If you delete the master index file (.MDX) then the next time you open the table will cause a popup message warning you the MDX is missing and if you proceed then the MDX reference in the table header will be deleted. To avoid that user interface error, first try to delete the MDX tags and once they are all deleted, the MDX file will be gone too.
Code:
DO WHILE LEN(TAG(1))>0
DELETE TAG TAG(1)
ENDDO- Thread starter
- #6
christer102
IS-IT--Management
I was asking about the NDX file. Thanks for all the help. Much appreciated.
- Status