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