Hi,

Working with remote MySql database and local VFP.DBC

Following code works alright:

sqltxt=''
text TO sqltxt noshow
	sqlexec(lnRet,"select myPrimaryId, mySecondayId,cDtTitle,
			cEnTitle, cDtMaterial, cEgMaterial,ceDtFormat, ceEgFormat,
			coalesce(DtPrtcopy,'') as DtPrtcopy,
			coalesce(EgPrtcopy,'') as EgPrtcopy,
			coalesce(DtSPrice,'') as DtSPrice
			from HORSART_WORKS","curHorsart_Works")
endtext
sqltxt = strtran(sqltxt,chr(10), '')
sqltxt = strtran(sqltxt,chr(13), '')
&sqltxt

cursor gets loaded.
However adding just one more field to this scenario viz:

sqltxt=''
text TO sqltxt noshow
	sqlexec(lnRet,"select myPrimaryId, mySecondayId,cDtTitle,
			cEnTitle, cDtMaterial, cEgMaterial,ceDtFormat, ceEgFormat,
			coalesce(DtPrtcopy,'') as DtPrtcopy,
			coalesce(EgPrtcopy,'') as EgPrtcopy,
			coalesce(DtSPrice,'') as DtSPrice,
			coalesce(EgSPrice,'') as EgSPrice
			from HORSART_WORKS","curHorsart_Works")
endtext
sqltxt = strtran(sqltxt,chr(10), '')
sqltxt = strtran(sqltxt,chr(13), '')
&sqltxt

will result in Error : "Command contains unrecognized phrase/keyword"

If I launch Sqlyog the 2ndquery is executed as it should be.

It seems to be there is a limit to the maxnmbr of characters, when I delete any column in the 2nd Select statement it results a correct cursor.

I am at lost what is going on, and would like to know how to solve this one.
Regards,

Koen