> 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
> from mySql
> ENDTEXT
> 		
> lnResult = sqlexec( lnRet, lcsql, "crsMyCursor")
> 

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

hello koen,
what is your field length in your sql table? that depends or u can use memo field in mysql to convert it into vfp memo. or u just increase the field length in mysql. or u need a new blank column in output cursor which is memo?

lnResult = sqlexec(lnRet,"SELECT *,SPACE(256) AS MyMemo From Your TableName_in_MySql","YourCursor")

Anil
(Fox is the solution for almost everything!!)