Specifying the table name in RecNo() will return the current record number of that table, as it is not associated with the SELECT - SQL.
Meaning, if that table is on record one when you start the SELECT - SQL it will always be a 1 in that field. Tracy -----Original Message----- From: Richard Kaye Sent: Thursday, March 20, 2008 7:07 PM Or perhaps specify the alias of one of the tables in the recno() expression. Not that I would do that, either, as it has probably as much meaning... <g> Alan Bourke wrote: > If you locked the entire table first, then using Recno() might just be > OK. Otherwise - doubleplus ungood -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 _______________________________________________ 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/[EMAIL PROTECTED] ** 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.
