Funny, I was literally thinking about this the other day myself. What prompted you to go this direction?
Are you binding the view also to your forms and then simply creating the update sql statements at save time, or using objects for the binding, in which case, I don't see why you'd use the view.. :) Have you run into any gotchas along the way? >I'm starting to take a different, hybrid kind of approach where I use >views for retrieving but then just do inserts/updates/deletes directly >into the VFP or MYSQL tables. Not sure if this simplifies or >complicates, but so far, so good in my experiences. I'm wondering too >if it aids at all in network traffic management? Probably not with >VFP. But I recall VB6 learning about ADO recordsets and the various >types of cursors you could create (e.g., "forward only" being the least >network intensive). > >-- >Michael J. Babcock, MCP >MB Software Solutions, LLC >http://mbsoftwaresolutions.com >http://fabmate.com >"Work smarter, not harder, with MBSS custom software solutions!" > > > [excessive quoting removed by server] _______________________________________________ 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 ** 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.
