Iames Pizzoli wrote:
<snipped>
I'm about to start a conversion of an application (of mine) from
plain VFP9 to VFP9 with a MySQL backend. I've just installed MySQL 5.0.22
(Windows version) on my dev machine, but in production there will be Linux
as server OS.
It's my first time with MySQL (and client/server in general). I'm
sure I'll have questions in the next future, but for now I'm interested in
tips/advices to help me in the data conversion phase. Is LOAD DATA INFILE my
friend here? And what is the best way to prepare the proper text file from
VFP? I guess COPY TO, but are some clauses better suited than other?
<snipped>
You are on the right track...
Whil Hentzen (hentzenwerks.com) is working on a new book that address
exactly what you want - VFP w/ mySQL. I've been doing some reviewing and
it looks like an excellent resource. Maybe Whil might chime in here with
when it will be available.
Another good book on C/S from a VFP point of view is Chuck Urweiler's
Client Server w/ VFP book - check out the hentzenwerk website for it.
Hope it's still available. It deals with mostly MS SQL Server as the
backend but most of the principles should apply.
Or just try and muck about and when you screw something up - come to us
for help... <g>
Matthew S. Jarvis
IT Manager
Bike Friday - "Performance that Packs."
www.bikefriday.com
541/687-0487 x140
[EMAIL PROTECTED]
_______________________________________________
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.
