FoxPro Memo and SQL

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

[JHausmann]

Use Access (jet).

[Edited by JHausmann on 03-20-2000 at 05:01 PM]

Unfortunately Access is not an option for me; the client
had a system already in place using Foxpro so I'm sort
of stuck with it.

Thanks anyway,
Erik

[JHausmann]

Using Access doesn't mean you have to stop using Foxpro. You can:

1) create an access table that has a memo field
2) create a link table that points to your foxpro database, in the same database
3) use a sql command to move the data from the access table to the link table.