That's what the AGAIN clause does. It's more efficient for VFP to just open the file as opposed to running a query. It's my understanding that sometimes Rushmore does something similar under the hood if it decides that it's faster than executing the query.
-- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Paul Newton Sent: Wednesday, January 06, 2016 4:07 AM To: [email protected] Subject: RE: Odd/inconsistent behaviour of DBF() Ted Interestingly if I issue USE DBF('tmpctran') AGAIN ALIAS TEST Then DBF('tmpctran') and DBF('test') return the same value ... so I have two cursors with, supposedly, the same DBF() Paul -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Ted Roche Sent: 05 January 2016 19:47 To: [email protected] Subject: Re: Odd/inconsistent behaviour of DBF() On Tue, Jan 5, 2016 at 11:35 AM, Paul Newton <[email protected]> wrote: > Richard > > I used the NOFILTER clause and a physical file was NOT created ... > > Paul > I believe that FoxPro aggressively caches both reads AND WRITES so the TMP file is probably not created unless it has to be. A small DBF takes little space in RAM and can be accessed in nanoseconds, while a file written to and then read from takes takes milliseconds. If you USE the file and then go look for it, is it flushed to disk at that point? _______________________________________________ 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/bn4pr10mb0913c871c099efd118220b56d2...@bn4pr10mb0913.namprd10.prod.outlook.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.
