>>So, the question is how to skip NNNN records in filtered table by oder of sorting in fast manner? Any ideas?
>
>Is there a specific reason that you want to use a filtered cursor?
Erik, there is no reason at all since basically I'm doing the following:
select * from tmp1 where fullyoptimizedcondition order by sortfield into cursor tmp1
and VFP just makes the cursor by setting filter on fullyoptimizedcondition and setting order tag to sortfield... Nofilter clause helps a little since if record number that will be selected is large than 500, then it will run forever...
As you see, all what I want is plain cursor which I can browse or whatever but instead I'm getting filtered tmp1 table where skip 50000 command causes indefinite lockup < g >
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer