Looks like it's a limitation of VFP ODBC driver. See
HOWTO: Add Records with Memo Data Using the Visual FoxPro ODBC Driver mskb #
Q208208. Take also look at
Re: OLEDB Update Memo Large Size Not Working Thread #
681778 Message #
681813.
>Hi All,
>
>I wrote in a few days ago about Updating a MEMO Field in my VFP 7 DB with my ASP script.
>
>Here Is The Error I am getting
>
>Microsoft OLE DB Provider for Visual FoxPro (0x80040E14)
>Command contains unrecognized phrase/keyword.
>
>
>I have narrow down the problem to I Can not have more than 254 Charaters going into the database even though the field is a memo field.
>
>Here is my SQL String
>
>UPDATE Faqs SET FaqQuestion = '" & Request.Form("FaqQuestion") & "',
FaqAnswer = '" & Request.Form("FaqAnswer") & "'
WHERE FaqID = " & Request.Form("FaqID") & "
>
>
>Does any one know why Fox Pro is doing this?
>
>Any help is greatly appreciated.
>
>Kind Regards,
>Tarran Walker
--sb--