I tried that solution and it is a very good one
It works well, as does the one suggested by Koen
Thank you
Rafael
El 24/03/2015 a las 11:09, Ted Roche escribió:
On Mon, Mar 23, 2015 at 6:34 PM, Rafael Copquin
<rcopq...@fibertel.com.ar> 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)
_______________________________________________
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/55119e0b.1000...@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.
