> 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

This works for me, no need to specify memo, fields > 255 are coverted to memo automagically:

m.lcOdbcDriver 	= "{MySQL ODBC 5.1 Driver}"
m.lcOdbcServer 		= "localhost"
m.lcOdbcPort 		= "0"
m.lcOdbcOption 		= "3"
m.lcOdbcDatabase 	= "xxxxx"
m.lcOdbcUser 		= "xxxxx"
m.lcOdbcPassword 	= "xxxxx"

m.lcOdbcDriver 		= "DRIVER="	+ m.lcOdbcDriver	+ ";"
m.lcOdbcServer 		= "SERVER="	+ m.lcOdbcServer	+ ";"
m.lcOdbcPort 		= "PORT="	+ m.lcOdbcPort		+ ";"
m.lcOdbcOption 		= "OPTION=" 	+ m.lcOdbcOption	+ ";"
m.lcOdbcDatabase 	= "DATABASE="	+ m.lcOdbcDatabase	+ ";"
m.lcOdbcUser 		= "USER="	+ m.lcOdbcUser		+ ";"
m.lcOdbcPassword 	= "PASSWORD="	+ m.lcOdbcPassword	+ ";"

m.lcString = ;
	m.lcOdbcDriver + ;
	m.lcOdbcServer + ;
	m.lcOdbcPort + ;
	m.lcOdbcOption + ;
	m.lcOdbcDatabase + ;
	m.lcOdbcUser + ;
	m.lcOdbcPassword

lnRet=sqlstringconnect(m.lcString)


m.lcSQL = "SELECT Articulos.notas FROM articulos Articulos"

lnResult = sqlexec( lnRet, lcsql, "crsMyCursor")

Carlos Alloatti