Why? Not sure why. But here are possible work arounds. If you are able to, chage your field type from Text to MediumText. That should bring in all the data.
Or if you cannot you could substr() the text field (as many times as you see fit).

>Salut Mike.
>
>That's it. A regular character field. But i need this field to be a memo. Any idea why?
>
>Thanks.
>
>>Salut JF
>
>>So what are you getting? A regular character field? Because in MSSQL you do get a memo >field from a TEXT type.
>
>>>Hi.
>>
>>I use this command to create a cursor.
>>
>>SQLEXEC(lnHandle, "SELECT * FROM test", "mycursor")
>>
>>I was expecting that data field type (in MySql) "TEXT", was the same as MEMO. But it does not seem to.
>>
>>I am using this cursor in a maintenance and my column is the recordsource of an editbox and behaving badly.
>>
>>Any suggestion are welcome.
>>
>>Thanks.