RE: import mySql memo into V FP (Posted by Anders Altberg) - www.foxite.com

> Did you try CURSORSETPROP("FetchMemo", .T.)?
>
> I have no problem retrieving memo fields (MySQL datatype as Text, MediumText, etc). They are automatically converted to memo in VFP using SQLEXEC().
>
> Another solution is to use CURSORADAPTER() where you can specify the field types exactly you want it.

Can you do that in the query?

SQLEXEC(handle, "SELECT col1, CAST(coltext AS MediumText ) AS memotext FROM ..", 'crsx' )

-Anders

Tip: click here to scan for Windows Registry Errors and Optimize PC performance

COMPLETE THREAD

import mySql memo into V FP Posted by Koen Piller @ 9/13/2008 12:01:41 AM

RE: import mySql memo into V FP Posted by Anders Altberg @ 9/13/2008 2:11:46 AM

RE: import mySql memo into V FP Posted by Carlos Alloatti @ 9/13/2008 5:05:20 AM

RE: import mySql memo into V FP Posted by Anil Sharma @ 9/13/2008 6:48:33 AM

RE: import mySql memo into V FP Posted by Koen Piller @ 9/13/2008 8:19:55 AM

RE: import mySql memo into V FP Posted by Anil Sharma @ 9/13/2008 8:24:21 AM

RE: import mySql memo into V FP Posted by Koen Piller @ 9/13/2008 12:37:00 PM

RE: import mySql memo into V FP Posted by Anil Sharma @ 9/13/2008 1:18:51 PM

RE: import mySql memo into V FP Posted by OM RAJAN @ 9/14/2008 5:12:12 PM

RE: import mySql memo into V FP Posted by Carlos Alloatti @ 9/13/2008 3:55:11 PM

RE: import mySql memo into V FP Posted by Anders Altberg @ 9/13/2008 3:07:51 PM

RE: import mySql memo into V FP Posted by Barak Ros @ 9/13/2008 10:40:00 PM

RE: import mySql memo into V FP Posted by Koen Piller @ 9/14/2008 12:59:37 AM

RE: import mySql memo into V FP Posted by Koen Piller @ 9/18/2008 12:22:38 PM

RE: import mySql memo into V FP Posted by Barak Ros @ 9/18/2008 12:34:45 PM

RE: import mySql memo into V FP Posted by Koen Piller @ 9/18/2008 9:30:17 PM

RE: import mySql memo into V FP Posted by Barak Ros @ 9/19/2008 12:24:45 AM

RE: import mySql memo into V FP Posted by Koen Piller @ 9/19/2008 12:34:17 AM

RE: import mySql memo into V FP Posted by Tom Saddul @ 9/15/2008 9:25:05 AM

RE: import mySql memo into V FP Posted by Koen Piller @ 9/15/2008 11:24:41 PM

RE: import mySql memo into V FP Posted by Tom Saddul @ 9/16/2008 7:12:32 AM

RE: import mySql memo into V FP Posted by Koen Piller @ 9/16/2008 10:30:28 PM

RE: import mySql memo into V FP Posted by Anders Altberg @ 9/18/2008 2:01:45 PM

RE: import mySql memo into V FP Posted by Koen Piller @ 9/18/2008 8:51:27 PM