-
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
-
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
-
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.