I had trouble displaying content of MEMO field in my edit box (myEditBox.ControlSource=cMyCursor.myMemo gives me ERROR INSTANTIATING OBJECT: my form class will not even open).
After getting clues from many helpful people on this forum, I found out that the MEMO field was retrieved as GEN field in cMyCursor.
I'm using VFP backend, will be converting to SQL SERVER (hopefully), & I'm using SQLEXEC to get cMyCursor:

lcConnStr="DRIVER={Microsoft Visual FoxPro Driver};" + ;
"SourceDB=myDatabase.dbc;SourceType=DBC;UID=;PWD=;"

THIS.lnHandle=SQLSTRINGCONNECT(lcConnStr)

lSuccess=SQLEXEC(THIS.lnHandleERCA,"SELECT * FROM myTable","cMyCursor")
SELECT cMyCursor
BROWSE

In the BROWSE window, myMemo field (of type MEMO) comes up with the word 'GEN' instead of the familiar 'Memo', and hence myEditBox.ControlSource=cMyCursor.myMemo does not work.

How can I use the SQLEXEC to retrieve MEMO field as MEMO from a remote VFP database so that I can display the content of the MEMO field inside myEditBox???

THANK YOU ALL!