Just tried this: USE sometable GO 10 && RECNO() = 10 SELECT ^ FROM sometable WHERE somecondition && returned 20 records ? RECNO(1) && Displays 10
Seems OK Laurie On 19 December 2014 at 07:43, Darren <[email protected]> wrote: > > That is my understating too. Do a ?select(0) before and after the query > to > confirm. > > -----Original Message----- > From: ProfoxTech [mailto:[email protected]] On Behalf Of Laurie > Alvey > Sent: Friday, 19 December 2014 5:35 PM > To: [email protected] > Subject: Re: SELECT SQL > > As far as I know, SQL SELECT uses its own (private) datasession so > shouldn't > affect record pointers in other sessions. > Laurie > > On 18 December 2014 at 23:09, Dan Covill <[email protected]> wrote: > > > > Tables don't have record pointers; only programs do. > > > > To the best of my knowledge and research (look up DBF header format), > > there is no concept of a 'record pointer' in a DBF. Yes, your running > > program that has the DBF open has a record pointer, and so does any > > other program that has the same file open, but they have no knowledge > > of nor control over each other's pointer values. > > > > A record pointer is NOT part of the relational database concept; > > although it would be pretty hard to implement a relational database > without one. > > > > Dan > > ---------------------------------------- > > > From: [email protected] > > > To: [email protected] > > > Subject: SELECT SQL > > > Date: Thu, 18 Dec 2014 14:45:15 +0000 > > > > > > Hi all > > > > > > Does anybody know if executing a SQL Select command/statement CAN > > > result > > in record pointers in open tables being moved? My testing seems to > > indicate that record pointers are NOT moved but I need to be sure. > > > > > > > [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/camvtr9e8nhd_wxrdz5yehnbc5mfmavtuzrkmvy57k5tqvva...@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.
