Subject Re: REINDEX
From Ken Mayer <dbase@nospam.goldenstag.net>
Date Thu, 11 Aug 2022 05:09:16 -0700
Newsgroups dbase.getting-started

On 8/10/2022 11:29 PM, Cornelius wrote:
> Ken Mayer Wrote:
>
>> On 8/10/2022 5:05 PM, Cornelius wrote:
>>> Hi there,
>>> I have a database with name system12 with a table stock.dbf
>>> If I do the following in the program will ths reindex the table.
>>> OPEN DATABSE SYSTEM12
>>> SET DATABASE TO SYSTEM12
>>> USE STOCK EXCLUSIVE
>>> REINDEX
>>> CLOSE DATABASE
>>
>> Well, it should. Why?
>>
>> Ken
>>
>> 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.

Suggest you find out why this is happening. Typically it's because
someone shut down the computer while the table was open, that kind of
thing ... Train your users to close their application before shutting down.

Ken


--
*Ken Mayer*
Ken's dBASE Page: http://www.goldenstag.net/dbase
The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp
dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm
dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm
dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm
dBASE DOS to Windows Tutorial:
http://www.goldenstag.net/dbase/DtoWTutorial/00_Menu.htm