Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bernard Bout
  Where is Bernard Bout?
 Brisbane
 Australia
 Bernard Bout
 To: Zaldy Santos
  Where is Zaldy Santos?
 Tokyo
 Japan
 Zaldy Santos
 Tags
Subject: RE: bind MySQL to DataGrid
Thread ID: 78733 Message ID: 78861 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Monday, October 10, 2005 3:15:00 AM         
   


Sure. That's why I suggested Cursor Adapters. Whatever data you connect to the data your front end works with is a VFP cursor. CA's work with any data backend. Of course you cannot use the builder for MySql but you certainly can use a Cursor Adapter to access MySql data.

You will need the MySQL ODBC driver to do this. Then it is a matter of connecting and getting the data.

Note there are some idiosyncracies with VFP and MySql data especially in the updates.

For more info on VFP and MySql check out Ed Leaf's site.(You will have to google for it)

> but isn't it vfp's grid can only be bound to vfp tables/cursors only?
> i actually use them because of their builders...err!
> pls help,
> zalds
>
>
>
> > I would suggest using a VFP 9 Grid and accessing the data using Cursor Adapters. Now binding is easy.
> >
> > > hi there gurus,
> > >
> > > i have a program created in VFP7 with SQL Server as back-end processing 200k+ records todate and it works fine.
> > >
> > > i decided to migrate to VFP9 with MySQL as back-end...
> > >
> > > my problem is this...
> > > i have a msdatgrd object in my form but i can't seem to bind to my MySQL table?!
> > >
> > > can anybody give me a sample code on how to do this?
> > >
> > >
> > > thanks in advance,
> > > zalds


ENTIRE THREAD

bind MySQL to DataGrid Posted by Zaldy Santos @ 10/7/2005 10:23:50 AM
RE: bind MySQL to DataGrid Posted by Bernard Bout @ 10/8/2005 6:06:58 AM
RE: bind MySQL to DataGrid Posted by Zaldy Santos @ 10/8/2005 8:04:59 AM
RE: bind MySQL to DataGrid Posted by Bernard Bout @ 10/10/2005 3:15:00 AM
RE: bind MySQL to DataGrid Posted by Mike Gagnon @ 10/8/2005 12:44:10 PM
RE: bind MySQL to DataGrid Posted by Barbara Peisch @ 10/9/2005 5:13:05 AM
RE: bind MySQL to DataGrid Posted by Ryan Lashway @ 10/9/2005 6:34:35 PM