In further thinking, you could do the SELECT ... INTO CURSOR and find your RECNO() field value. The RECNO() of the cursor would be the relative position. Should work in all versions of VFP.
Fred On Tue, Sep 20, 2011 at 10:48 AM, Fred Taylor <[email protected]> wrote: > There are no functions that return a position relative to the index. If > there aren't too many records, you may be able to SELECT RECNO() FROM table > ORDER BY your_order INTO ARRAY xxxx, then search the array for the RECNO() > you want. The found index into the array will be your relative position. > > This is limited to about 65000 records for VFP8 or earlier. VFP9 is only > limited by available RAM. > > Fred > > > > On Tue, Sep 20, 2011 at 10:03 AM, Michael Savage <[email protected]>wrote: > >> I have a table, with two indexes. (In a cdx file) >> >> I need to know the new place in the table when the order changes. >> ie if it is the second record in the table in sort order #1, what is it >> in order #2. >> >> Let say that in order 1 it is the 2nd record, but in order #2 it would >> be the fifth record. >> How do I find out when I switch order, what position it's in? >> >> Can't use recno(), what other functions is there. >> Mike >> >> [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajcbksp2ujrwbgs1mnfn0-jyegp7b2grwsa1v_snhmjbs6m...@mail.gmail.com ** 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.
