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