Hi All


We do Computer Adaptive Testing here on up to 116 machines at any given time. This morning, 2 machines are sending back a "Corrupted index" error when the app inserts into a Stats table: The line of code is:

      Insert Into indvstats (Scn, Idno, Resp, Key, TestDate, QstType, SeqTime) ;
         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'))),;
         date(), 'R',datetime())

The insert happens and then this error is triggered.

Now I understand how this can happen, but the interesting thing is that the two students it happened to were moved to two different machines and got the same error. When I went over to check these machines, I had no problem using a 'dummy' number - but if I tried to use one of the student's control numbers I got the same error. We had about 50 people testing today and these are the only two that had issues.

So, my question is: Has anyone else seen anything like this? And should I just trap for this error and ignore? Does anyone have any ideas about this? Anyone?? Anyone? Bueller?

Thanks

Dorris