Stephen Russell wrote: > On Thu, Apr 22, 2010 at 11:50 PM, MB Software Solutions, LLC > <mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: >> Try to avoid using a single view to update multiple tables via the >> native view means. The problem comes with the primary keys....if the >> view doesn't have a primary key for a table, how will it know which >> record(s) to update? You might have to resort to using explicit code to >> do the updates. > -------------------------- > > The power of the guid as the PKey suddenly shines bright! > > When you assign the guid and put that in the row's memory container > before the insert it is all good at insert.
Whether GUID or integer keys, he still faces the same problem. GUID doesn't bring a magical solution to this, unless I'm misunderstanding. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ 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/4bd1f69a.1050...@mbsoftwaresolutions.com ** 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.
