>>>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 >
Vladimir,
How large your table? Did you try index it and then skip 50000?
I had similar app (250,000 rec , SKIP 40000) SKIP took about 1 min on P350. Still slow but was acceptable.
And I tried SCAN NEXT...ENDSCAN , but it took about 2 min.
HTH
Oleg