I am using MSSQLServer 2000 and using the following command to retrieve a record which contains a text field in the SQLServer table:

lccmd = "Select * from messages where lactive = 1"
lnsuccess = SQLEXEC(nhandle,lccmd,"mycursor")

When I access mycursor the text field contains the usual foxpro "memo" designation but I cannot put my cursor into the field or open it and the lower case "m" in memo indicates there is no value in the field although the SQL table does contain a short line of text.

What do I need to do to have the SQLEXEC also pull in the text field value?

Paul Montgomery