Hello,

I have a FoxPro table with a Memo field defined which
is usually less than 255 characters; but occassionally is
more. When I try to update the field via SQL with a string
that is longer than 255 characters, I get an unrecognized
command syntax error (or something similar). This occurs
whether I do it through JET or through the FoxPro command
line. However, if I copy the same string to the clipboard
and paste it directly into the field, it updates fine.
I am using VB6 with ADO (MDAC 2.5, but had the same problem
with MDAC 2.1) and Visual Foxpro 5.

I really need to be able to pass the strings which are
longer than 255 characters to the memo field. Anyone
have any suggestions?

Thanks in advance.

Erik Shepard