On 12/13/2012 10:18 PM, Ken Dibble wrote:
I think everything having to do with VFP's built-in buffering system, including views, sucks. It seems like you have to stand on one leg on alternate Wednesdays under a full moon to get data written to the disk and reliably returned to the user. Update-conflict detection actually doesn't work at all if you don't bind data to something, and data binding takes a huge amount of control away from the developer. I ended up leaving buffering turned off and writing my own framework code to detect and resolve update conflicts.
Your comments reminded me of Charlie Coleman, who had his own framework to circumvent views too. Worked great for him. I too developed my own framework similarly for my use in working with MySQL backends. Works great for me.
And while I haven't yet implemented a live system using a non-VFP database, in all my testing with MySQL I've found SPT to be perfectly adequate and a lot easier to understand than views.
+1
But I'm sure there will be some people who will tell me, or you, that we are, indeed, doing it wrong. Hence the controversy.
Some folks say CursorAdapters are the way to go for sure (now that the last patch fixed problems in their initial design) but I had already moved to my own framework. During VFP8 days when Ed Leafe said that CAs had issues with MySQL, I guess I mentally closed the idea of engaging them in my apps, since I use MySQL on the backend.
-- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ 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.
