I thought somewhere in the help it equates RW & NF. READWRITE or NOFILTER means that there will be a physical file created on disk (I believe in your OS temp files location) with the appropriate data as opposed to in memory only or a USE...AGAIN in a different workarea of the source table. That's why you can modify the table structure, add multiple indexes, etc. The beauty of using the cursor instead of INTO TABLE mytemptable from my POV is it will get garbage collected for you automagically when the cursor is closed.
-- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Gene Wirchenko Sent: Friday, July 11, 2014 1:13 PM To: [email protected] Subject: RE: Discovered something totally cool by accident! At 02:58 2014-07-11, Dave Crozier <[email protected]> wrote: >Readwrite has the same effect as NoFilter and also allows you to write >to the cursor. The docs do not support your statement. There is nothing under SQL SELECT stating that READWRITE would necessarily use or not use a temporary cursor. To be safe, I have the odd filter created using both options. [snip] Sincerely, Gene Wirchenko _______________________________________________ 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/DF1EEF11E586A64FB54A97F22A8BD04423A28F8305@ACKBWDDQH1.artfact.local ** 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.
