On Mon, Mar 23, 2015 at 6:34 PM, Rafael Copquin <[email protected]> wrote: > I have this cursor containing a list of clients. > > 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? >
LPARAMETERS lcCurrentName SELECT COUNT(*) AS PAGENO FROM Clients WHERE Clients.Name<lcCurrentName INTO ARRAY laPage RETURN (laPage[1]) (Two clients with the same name would have the same "Page number") (Also WHERE NOT DELETED() if you have deleted records. Make sure you have a matching tag, for Rushmore) -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ Post Messages to: [email protected] 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/cacw6n4swsqnerbi9atqmwkqworf83n5mw2k77-0nfahgbd0...@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.
