Kevin Cully wrote: > I'm working on a new project that is VFP to a MySQL back end. I'm not > using views in the app, but I've created one as a quick way to access > the data in development. My Text field is being returned as a memo > field in VFP. > > I'm hitting a MySQL 5.0 install with MySQL ODBC version 3.51.12.00. >
Steve, Like Kevin, I'm using VFP9 against a MySQL (but version 4) backend, and text fields come back as memo. Also like Kevin, I'm not using remote views, but instead of using a meta-table to hold my SQL definitions, and then setting the properties via SQLEXEC. Check out the project I posted on Ed's site for an example (see below for link). It's a simple (imo) framework for using MySQL or other RDBMS' as the backend. Specifically, the project worked for MySQL OR VFP, all by just flipping a switch. CursorAdapters are supposed to do the same thing, but I steered clear on them since VFP8 and never needed to revisit it. I do know others however who use CAs with MySQL without issues, so you might look into that as another option. http://leafe.com/forum/viewtopic.php?t=1860&sid=f8177dd3bcf5dfbc302129d4dfba8c0b or http://tinyurl.com/2qwykn or http://preview.tinyurl.com/2qwykn -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
