At 2007-12-05 20:58, Stephen Russell wrote: >On Dec 5, 2007 12:39 PM, Dan Olsson <[EMAIL PROTECTED]> wrote: > > BTW (which I'm sure you know) - an easy way to do this is to SELECT > > the required records/dbfs into a CURSOR, which automatically makes it > > exclusive - AND FP will take care of the housekeeping for you, ie > > deleting stuff when you're done using it. > >I don't think it does that all the time, does it? I mean if your code is: >use mytable in 0 >Select * from myTable into cursor mT >You don't get a copy of the table into ram, you just see a fake copy >of the table. Correct? Say the table was 500 meg. The select >isn't doing a copy to a temp table first. Or am I remembering some >other process?
No, you're right. If you want to be sure the cursor is a real tempfile on disk you can use the NOFILTER-clause in VFP9 or in older versions fool VFP by doing something like: SELECT *,.T. FROM... ****************************** * Dan Olsson * <mailto:[EMAIL PROTECTED]> * <http://www.dolittle.se> _______________________________________________ Post Messages to: ProFox@leafe.com 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.
