>>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
Peter Robinson ** Rodes Design ** Virginia