> 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
hi
I have this problem also and I am using vfp6
you need to install the latest odbc connector 5.1 and then you need to set a flag called
"LIMIT column size to signed 32-bit range" to check (even if it sound like it the opposite)
this flag can be found when clicking Details button on tab "Flag 3"
you also can check the flag "allow big results set" on tab "Flag 1"
that works for me.
you can also take a look here:
"Wrong field type for longtext is returned to Visual Foxpro, data are truncated"
http://bugs.mysql.com/bug.php?id=30890barak