Sorry Gene, You are wrong. By default sql select statements cannot update the main table unless they are so programmed and making the cursor readwrite in effect detaches your cursor completely from the base table - in other words you get an actual cursor table created as opposed to the "pseudo table" which is simply a mirror into the original table using some nifty Rushmore processing.
Using READWRITE ALWAYS creates a physical cursor which is read/write enabled on the local machine so you can then do with it what you want. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Gene Wirchenko Sent: 11 July 2014 18:13 To: ProFox Email List 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 [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.
