Deepak
I won't even pretend to figure out just WHAT your index is supposed to do/be but it looks very unusual to me. For instance, correct me if I'm wrong, community) but what is the point of having part of an index as EOF() (surely only 1 record will satisfy that) ???
Anyway, notwithstanding, try "LOCATE" to move the file pointer to BOF, after setting the index, to see it activated.
HTH
Terry
>Hi,
>
>I have a temp index issue. I have a form with two index option. One is normal index and other is temporary index related with other table. When I add any record and select the order option as temporary index, this does not refresh the index. If I close the form and then reopen the same. This got refreshed.
>
>Please help.
>
>I am using something like this.
>
>
>Select a
>set rela to x to b
>index on (eof(b),a.x,b.x1) to xidx
>set order to xidx
>
>
>Thanks in advance.
>
>Deepak.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.