Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
RE: IMPORT MYSQL MEMO INTO V FP
 From: Tom Saddul
  Where is Tom Saddul?
 Manila
 Philippines
 Tom Saddul
 To: Koen Piller
  Where is Koen Piller?
 Santpoort-Zuid
 Netherlands
 Koen Piller
 Tags
Subject: RE: import mySql memo into V FP
Thread ID: 194026 Message ID: 194283 # Views: 33 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Monday, September 15, 2008 9:25:05 AM         
   

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.



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