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 10:23:01
 
 
To
01/02/2000 09:22:47
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00325473
Message ID:
00325558
Views:
26
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform