Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record position from top of table with index/filter
Message
From
24/02/2001 06:42:33
Fausto Garcia
Independent Developer
Lima, Peru
 
 
To
24/02/2001 02:58:13
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00479180
Message ID:
00479186
Views:
25
Hello Vladimir,

You could try selecting the records from the table using your indexing or filtering criteria into a cursor, then seek for the desired record and ask for the RECNO() into the cursor. For big tables and maximum performance you can take advantage of the rushmore technology.

Hope this ideas help!

>Hello everybody,
>
>Another problem which seems to have no solution so far ;(. Let say, I have a table which can have index and/or filter in effect. I can find the record by its Primary key which is known. what I want to know is what is position number of given record in given index/filter conditions. The only way I we found so far is skip records until you reach the top of table and count number of skips. but it is DAMN tooo slooooow, especially on big tables.
>
>Does anyone know a trick how to perform this task faster?
>
>
>TIA
Solo se que nada se

Fausto J. Garcia Pino - MCSD.NET
.NET, Oracle, Tronador & Fondismo!
Previous
Reply
Map
View

Click here to load this message in the networking platform