>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")
Did you try:
SQLEXEC(lnRet, "SELECT Id, Text, LastUpdate FROM MySqlTable", "crsMyCursor")
or
SQLEXEC(lnRet, "SELECT Id, CAST(Text AS BINARY) Text, LastUpdate FROM MySqlTable", "crsMyCursor")