Subject Re: REINDEX
From Akshat Kapoor <akshat.kapoor@kapoorsons.in>
Date Thu, 11 Aug 2022 13:49:54 +0530
Newsgroups dbase.getting-started

Good Afternoon Cornelius,

>>> OPEN DATABSE SYSTEM12
>>> SET DATABASE TO SYSTEM12
>>> USE STOCK EXCLUSIVE
>>> REINDEX
>>> CLOSE DATABASE

>> I find that customers complain of losing data on table. If I go into file I get message that index corrupted or outdated. If I then copy file onto my pc. Index the file and put it back on customer pc  and it then works again. I hope doing this before they use the file it will work correctly.

I would recommend that you do not do it everytime. It may be time
consuming.

But I add an pushbutton of rebuilding indexes in my app. So I reindex
only when required.
(A legacy option from the dos days when index corruption was frequent)

Regards
Akshat