Thank you! :)
Go grab the ODBC driver for mysql. Install and create a DSN for your mysql
database.
Then go into VFP and open your DBC, add it as a connection.
Now you can add updateable views of all your mysql tables into it and use
them like you could any other remove view.
NOTE: I've spent the last 2 months working with FP & SQL server, using views
like this is not like using FP tables. There are a LOT of problems. We got
around most of them by either :
1: using SQL passthrough (sqlexec, etc)
2: Using ADO
HTH,
Cal
http://www.calevans.com
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "Cal Evans" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 12:05 PM
Subject: Re: FoxPro6 and MySQL, odbc
>
>
> Any specifics?
>
> Informative/interesting articles on your Nerd Herd web site, Cal !
> Better fix <INPUT TYPE="hidden" NAME="item_name"
VALUE="ConsultaingAssistance">
>
> I have the Que book, "Special Edition, Using Visual FoxPro 6", but all it
ever
> discusses is how *other* applications can access _FoxPro's_ database. I
don't
> want to do that. I'm considering this really great program (that someone
else
> designed) in FoxPro, but I don't want to use the FoxPro database (it's too
> Micro$oft-oriented... I don't trust it). Maybe FoxPro has since obtained
some
> functionality for being able to access foreign databases. Other than SQL
Server
> (or Access), that is. I like my databases to be located on Unix servers
(the
> type that don't crash).
>
> Thanks,
> Charles Kirby
>
> ["In a world without fences, who needs Gates?]
>
>
>
>
>
> "Cal Evans" <[EMAIL PROTECTED]> on 05/29/2001 10:08:36 AM
>
> To: Charles Kirby/Usdcsdny@&2DC-NYS-Notes, [EMAIL PROTECTED],
> [EMAIL PROTECTED]
> cc:
>
> Subject: Re: FoxPro6 and MySQL, odbc
>
>
>
> within VFP it is.
>
> Cal
> http://www.calevans.com
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, May 29, 2001 8:50 AM
> Subject: FoxPro6 and MySQL, odbc
>
>
> >
> >
> > Hi, I see there are ways to have MySQL obtain data from a FoxPro
> database--using
> > ODBC--which is very nice, I'm sure.
> >
> > However, is it possible to run a FoxPro program that gets data from a
> MySQL
> > database??
> >
> > Thanks!
> >
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
>
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
