Ok, the early testers have reported success, so I guess it's ready! Here's the download link below. Backend setting is in the LOADER.INI file. Try it with the VFP backend, and then try it with the MYSQL backend. This project is a follow up to my presentation at FoxForward 2006 on n-tier design. Shown more in this example is how you can do so many things in the Data tier (like manipulating raw data before returning to the UI via BizObj---using Chain of Responsibility pattern as I described at FF2K6). I believe this project is fully functional too for both backends, unlike the example I used at FF, and I think the DataObj has some good methods in it that can become the framework for future designs as well. Instead of using VFP views, I've taken a different approach, using meta-data in the SQLDefs.dbf table. There's a column called cSQL that has the default SQL, and then overriding columns for both VFP and MYSQL should the need arise (for example, where concat is a MySQL function not available in VFP used to chain name parts together, whereas the VFP version uses ALLTRIMs with a + operator). The MySQL database resides in a test database on the web at my ISP, made specifically for this "open source" project. The database design was built with several foreign keys so as to try and facilitate optimizations for large datasets as the database would grow.
You can also gleam other tidbits out of this app's code, like for example how I audit usage, or perhaps how I log errors online and them email them with blat. http://mbsoftwaresolutions.com/demos/vfp/mbss_piecerate.zip Feel free to ask any questions! You need to have the MySQL ODBC driver (version 3.51) installed on your machine. I've got a copy here: http://mbsoftwaresolutions.com/downloads/mysql/Setup.exe All comments welcomed. Thanks, --Michael -- 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 ** 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.
