At 23:46 2014-07-13, Dave Crozier <[email protected]> wrote:
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.
Where is this documented by Microsoft? (If it is not
documented, then you really can not count on it.)
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.
Where is this documented by Microsoft? (If it is not
documented, then you really can not count on it.)
I really do not like depending on something undocumented. It
is much easier to add another keyword to the statement and not have the worry.
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/
** 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.
