>>What does "index is not working" mean?
>
>If I use the following commands
>

>     workdate = sclhist.datetime
>     count for sclhist.datetime = workdate
>

>The count returns zero. If I do the same thing with the "restored" table (before the reindex) the count returns 1277.
>I have checked and all 1277 of the data records are present.


Norm, I have seen problems very much like this. In my case other formulations would work such as:

count for schlhist.datetime >= workdate -1 and schlhist.datetime <= workdate + 1

or something like that.

I fixed my problems by reappending all of the records in the table to an empty structure.

Peter Robinson