No, you can read and write the data. The problems arise when old
"fox-jockey's" like myself try to treat the remote views exactly like dbfs.
No can do.
When creating your remote views make sure you go to the update panel and
tell it you want to actually send the sql updates. (You have to specify a
primary key for the checkbox to become available)
In short, on the project I'm working on right now we adopted the following
conventions:
1) If we have a screen that is editing a single record (like a customer
record) we create a customer object that used ADO to read and write to the
ODBC connection. (We've actually got a cool little object generator that
writes the code for us!)
2) If we need a cursor for a grid, we use SQL Passthrough. it is possible
to use ADO and another fll that can be found on the MS website to convert an
ADO recordset to a VFP cursor so you can attach a grid to it but I chose not
to do that.
3) If it's a small table (less than 200 records) then we left the existing
FP code in but removed any code that won't work with views. (indexes,
relations, locks, etc.)
I didn't mention but we are converting a 2.6 app to VFP w/ SQL. So there is
a ton of legacy code. You probably won't have to deal with that.
The bottom line is if you are careful, you can do it without a problem. But
it's not 'just like' writing FP code.
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 1:21 PM
Subject: Re: FoxPro6 and MySQL, odbc
>
>
> Ah, yes, I remember seeing some of this COM or ADO stuff in the Que book,
plus
> the SQL passthrough stuff. I remember putting the book to one side for
some
> reason, and that reason follows:
>
> It looked to me as if you certainly *could* manage to *read* data from
another
> machine, but (tell me if I'm right) it looks as if there's no way to
UPDATE or
> INSERT data into the remote database. Of course, it already looks pretty
> involved, especially if you don't just go Micro$oft's way and use the SQL
> Server.
>
> CK
>
>
>
>
> "Cal Evans" <[EMAIL PROTECTED]> on 05/29/2001 01:18:08 PM
>
> To: Charles Kirby/Usdcsdny@&2DC-NYS-Notes, [EMAIL PROTECTED],
> [EMAIL PROTECTED]
> cc:
>
> Subject: Re: FoxPro6 and MySQL, odbc
>
>
>
> 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?]
> >
> >
>
>
>
>
>
>
>
---------------------------------------------------------------------
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
