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: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 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: 194031 # Views: 57 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Saturday, September 13, 2008 2:11:46 AM         
   

> Hi,
>
> I am sure it is easy done, however I dont seem to be able to succeed to import > 255 characters from mySQLtable.memo field into a VFP.cursor with
>
>
> 
lnRet=sqlstringconnect('Driver='+lcDriver+';Server='+lcServer+';Database='+lcDatabase+';User='+lcUser+';Password='+lcPassword+';Option='+lcOption)
> 
> TEXT TO lcSQL noshow pretext 15 TEXTMERGE
> select id,
> CAST(Text as M) as Text,
> CAST(lastupdate AS datetime) AS lastupdate
> the MySQL ODBC from mySql
> ENDTEXT
> 		
> lnResult = sqlexec( lnRet, lcsql, "crsMyCursor")
>

>
>
> Anybody around to correct my syntax?
>
> Thanks,
>
> Jockey2

Does MySQL know what the datatype Memo is. The SQL command goes to the MySQL ODBC provider. When VFP sees it's more than 255 it would automaticslly use a Memo. Try withouyt CAST AS Memo.

-Anders



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