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 _______________________________________________ Post Messages to: ProFox@leafe.com 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.
