Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Skip large number of records when Filter is in effect
Message
From
01/02/2000 08:55:26
 
 
To
01/02/2000 08:41:44
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00325473
Message ID:
00325516
Views:
23
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform