Mark Stanton wrote: > Ok, so you've both (Ed & Ted) put more or less the same scenario. > > Encouraged by Ted's (wholly accurate, of course) outline of how to do > this "manually", and the VFP view wizard, how about the following. > > My view (aka "join") works by linking foreign and primary keys > ideally. To update it probably requires all primary keys to be > included. Then doesn't it become simple? I've got the primary keys > for all the tables I want to update. Ok, *if* I don't include those > keys or *if* I don't have primary it won't work. > > Of course, I'd still like an answer to my previous question. If this > is really not doable and views can only update one table, how much of > an advantage are they really, except to give server tables a "local > presence"? > >
Are we talking about local views (VFP backend), remote views (non-VFP backend), or just the concept of views in general? Charlie Coleman uses a concept where he does SPT to get cursors and then makes the updates himself (via code) instead of dealing with views. I'm doing that somewhat anymore too with non-VFP backends (in my case, MySQL). -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ Post Messages to: [email protected] 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.
