I have this cursor containing a list of clients.
If I do not set any order (set order to 0), the records are shown in
physical order, so if I move the pointer 100 positions down, the record
position is given by recno(), in this case it would be 100.
However, if I order the records by company name and move the record
pointer 100 records down, even though the position would be 100 records
from the top, recno() is not going to tell me where I am.
I need to show that I am in the 100dhs position from the top, regardless
of the order.
I am dealing with a table containing 3 million records, and the
requirement is that the record position be shown very fast.
To clarify, I select the table with the 3KK records and try to find a
certain company. Because the table is now ordered by company name, I
can't use recno() to tell in which position the found company is. If I
move the pointer down or up, the position should move one up or down.
For instance, seek 'WIDGET CO'
The actual record number, as per recno() could be 2348897. However that
record position in the cursor could be 1200, if the pointer is moved one
down, the position would be 1201, or if it were to be moved one up, the
position would be 1199.
So, how can I determine the record position as opposed to recno() if the
table is in any particular order, such as company name ?
Is there a function that can be used?
Rafael Copquin
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/55109504.5000...@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.