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!