Hi Bobby! Ajoy Khaund wrote: > Michael, > > As you progress can you note down the steps you have done to the Vfp app to > connect to MySql and what exactly do you download to have MySql running on a > single desktop m/c. > > Say something like: > > Step 1. Download MySql from WWW....... and install MySql(any particular > version) > Step2. Convert existing Vfp tables using stru2mysql_2.prg > Step3 In the main form connect to server > Step4 As you open each form some data has to come to the fields so how do > you get the data for the form. > Step5 and so on > > It will be helpful to lot like us who have not gone that way but might one > day. So then we wont have to keep asking you.
First, I don't mind anyone asking. I actually like to help others if I can, because so many here have helped and continue to help me. That's what makes ProFox so great. Sure, we might disagree on political and religious stuff, but as for Fox stuff, we're all here to help each other (or at least you should be!). As for converting your app from Fox to something else: it's not going to be easy if you've engrained xBase style coding into all of your app. It's best if you've started with an n-tier design approach. I uploaded an app on Ed Leafe's downloads page (http://leafe.com/dls/vfp) last year that I demoed at FoxForward 2007. Check that out. Basically, separate your UI from your data access, keeping in mind the "chain of responsibilty" each player in your app is responsible for. For example, your app's form doesn't open the data tables in the form.load (and definitely not the data environment as the conventional approach was). Instead, your form calls the data access object to give it a cursor that it expects. This means you need to think in terms of client-server approach---where you get exactly what you ask for---instead of just "USE MyTABLE." Check out the "open source" project I posted there and how it works. You may need to change the connection string to the remote database, and if so, just let me know and I'll research that for you. I'm pretty sure I posted it on here awhile back so search the ProFox archives for the updated connection string. This n-tier approach, if you can get used to using it, will help you too when you move to other languages. Think of using datasets like subset cursors instead of using tables as a whole. Good luck, and ask anything, anytime! Just don't be a troll! <eg> _______________________________________________ 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.
