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/[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.
