tablename.cdx size becomes 0K

[Renebear]

Hi folks,
I have a situation that there are times my tablename.CDX size becomes 0K (zero in size) and it creates problem when I start using the table. How can I prevent this .CDX to have a 0K in size.
Would the rebuilt of the index fix this problem.
I appreciate you sharing your expertise regarding this. Many thanks.

 

[Mike Gagnon]

ReneBear

I have a situation that there are times my tablename.CDX size becomes 0K (zero in size)

That means you have a corrupted index. I would suggest you try to determine which process causes your index file to be corrupted and fix it. One instance might be that the application crashes in the middle of saving to the table.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[rgbean]

And hopefully before Craig can respond -)), go to his web page -

http://www.craigberntson.com/articles.htm

- and read "Avoiding Table and Index Corruption".

Rick

 

[craigber]

FYI, the articles are on a subweb.

http://articles.craigberntson.com

will get you there.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"