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 Ellenoff wrote: > I've been having all kinds of trouble writing some generic code to > create remote views programmatically from a MySQL 5 database, and I > believe I've narrowed down the problem, and wanted to see if anyone > else has seen this and has a workaround.. > > When I a create remote view programmatically, any fields that are > TEXT fields in MySQL 5 are coming back as C(0).. > > I confirmed this infact using SQLColumns(handle,"FOXPRO"), which > indeed shows C(0) as the type for all the TEXT fields on the backend. > > This surely is a bug, but is it a VFP bug, a MySQL bug, or an MySQL ODBC bug? > > What can I do to work around this? Has anyone else seen this problem? > > Thanks- > Steve > > > > > [excessive quoting removed by server] _______________________________________________ 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.
