Michael Thankz Must have missed that before. Right not Ed's server is showing busy and download has not started. I will go thru that and then get back.
Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785 001 Assam, India Tel: 91-376-2351288 Cell: 91-94350-92287 Mail: [EMAIL PROTECTED] Mail: [EMAIL PROTECTED] "Walking on water and developing software from a specification are easy if both are frozen." - Edward V. Berard, "Life-Cycle Approaches" -------------------------------------------------- From: "MB Software Solutions General Account" <[EMAIL PROTECTED]> Sent: Sunday, June 01, 2008 11:03 PM To: <[EMAIL PROTECTED]> Subject: Re: a HUGE THANK YOU to Kevin Cully and Ed Leafe for thestru2mysqlcode!!!! > 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> > > [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 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.
