>>>>>What data type do I need to use in MySQL 5 to get a memo field in VFP. All data retrieval will be via SPT, no remote views.
>>>>>
>>>>>Thanks to all.......Rich
>>>>
>>>>
http://www.perlmonks.org/?node_id=28609>>>
>>>We set the field up as TEXT. However, if I do a SELECT which brings down an empty cursor, the result is a Character field with a Length of 0. If I bring down a record where the actual length of the data is 100, I get a Char (100) field. It is only when the MySQL data field is larger than 254 that I get a memo field.
>>>
>>>Is there any way I can set it up to always get it to come down as a memo field?
>>
>>Darn, you're using VFP8. I wanted to suggest CAST approach.
>>
>>I'm not sure then, sorry.
>
>I'm not sure how CAST would work even if VFP 9. It's something I would do after the cursor has been downloaded. I can fudge the same thing in VFP 8 if I need to.
>
>Thanks for your help......Rich
Try to use cast and convert to varchar(256).
If it's not broken, fix it until it is.
My Blog