Is this true? Have you tested it? With a cursor readwrite, you're forcing an unfiltered cursor view, so the recno() should be sequential.
On Thu, Nov 20, 2014 at 12:34 PM, Rafael Copquin <[email protected]> wrote: > Recno() is not good, because depending on the filter you get numbers with > "holes", like 1,2,35.56,etc. > I need a sequential numbering, from 1 to rowcount > > Rafael Copquin > > El 19/11/2014 18:41, Stephen Russell escribió: > >> On Wed, Nov 19, 2014 at 1:02 PM, Rafael Copquin <[email protected] >> > >> wrote: >> >> I am pulling a set of records from a big table, based on a filter >>> condition in the select statement. >>> I also want to create a field with the sequential number of those >>> records. >>> >>> Example: >>> >>> select *, (function to number records) as recnbr from bigtable where >>> filtercondition into cursor curFiltered readwrite >>> >>> What I need is a function or method to fill the recnbr field with >>> sequential numbers, starting at 1 such that the resulting filtered set >>> looks like: >>> >>> coname city recnbr >>> Widgets inc New York 1 >>> John Doe's New York 2 >>> etc >>> >>> The filter is the city (New York) and the table has more than one million >>> records >>> >>> I know I could select the recnbr field as zero and then use a scan >>> endscan >>> construct to replace it with the numbers, like >>> ------------ >>> >> >> >> Isn't recno() already doing that? >> >> Select *, recno() from curFiltered >> >> >> >> > [excessive quoting removed by server] _______________________________________________ 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/CACW6n4uD+h=6k_uq_62ezo6e57uzxg13_2++_isetzchdp+...@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.
