Gilbert M. Hale wrote: >> To add an option to Stephen's, you can look at using CursorAdapters >> if you're using at least Fox 8. > > Perhaps Ed can weigh in on the use of CursorAdapter with VFP8 and > MySQL. It seems to me he ran into a problem with the MySQL ODBC > driver selected for a VFP8-MySQL project last year, and ended up > using SPT. SPT worked great, but it was a new app created with SPT > in mind. If you can get around the MySQL ODBC issue the > CursorAdapter would indeed be a nice "get-me-by".
When I first saw Cursor Adapters I thought it was the best way for Fox to handle the backend. Then I tried it. After wasting 2 days on SqlServer, XML, MySQL I chunked the idea of ever looking at it again.
CurosorAdaper = M$ hype IMO.
Stephen Russell S.R. & Associates Memphis, TN 38115
901.246-0159
©2005 Stephen the Cook |