Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Barbara Peisch
  Where is Barbara Peisch?
 Oceanside
 California - United States
 Barbara Peisch
 To: Zaldy Santos
  Where is Zaldy Santos?
 Tokyo
 Japan
 Zaldy Santos
 Tags
Subject: RE: bind MySQL to DataGrid
Thread ID: 78733 Message ID: 78812 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Sunday, October 09, 2005 5:13:05 AM         
   


> 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


AFAIK an MSDataGrid needs to be bound to an ADO record set. If you don't want to get into dealing with ADO, then I suggest you use the native grid and use a remote view or CursorAdapter.

-BP
www.peisch.com

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