Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Record position from top of table with index/filter
Message
De
24/02/2001 06:42:33
Fausto Garcia
Independent Developer
Lima, Pérou
 
 
À
24/02/2001 02:58:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00479180
Message ID:
00479186
Vues:
23
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!
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform