>OK then, I don't know if this will be faster, but I will give it a try:
>
>
select RecNo() AS RecNo, SortName from tmp1 where optimizedcondition;
> order by sortname into cursor tmp2 NOFILTER
This sould give a smaller cursor. Then:
Thanks for advice but recno() in selects don't return proper values, it is filled with 1 ;(, so it won't work either, huh, pretty stupid problem, why MS can't provide use the function or whatever else to let us know the record number by index tag not by physical order...
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer