Hey All

We just ran a mass test on an application and we kept getting "Index file....\indvstats.cdx is corrupt, please rebuild index".

My question is, what are the likely causes for this? We had, essentially, 20 machines banging on this file.

The table in question has 4 fields, is indexed on one of them and has data being inserted into the table from this application

The insert in question is:

Insert Into indvstats (Scn, Idno, Resp, Key) ;
Values (Alltrim(Str(StudentControlNum)), ReadTest.Idno, ;
Iif(answer = 'A','1',Iif(answer = 'B', '2', Iif(answer = 'C','3','4'))),;
Iif(ReadTest.Key = 'A','1',Iif(ReadTest.Key = 'B', '2',;
iif(ReadTest.Key = 'C','3','4'))))


Yes, this table is part of a container, but buffering is not turned on.

Would someone be so kinds as to point me at all the other times this question has been answered, since I can't search?

thanks