Hi,

I'm developing a C#.NET application that writes to a FoXPro database.
I cannot seem to update memo fields with strings longer than about 400 characters, even if I break them up into chunks of 254.

My querystring looks something like this, but much longer with a lot of fields:

SqlStr = "update customer set email='" + email + "', " +
"phone='" + phone + "', " +
"comments=" ;
for(i=0;i<=count;i++)
{
SqlStr = "'" + aMomoField[i]+ "'+ " ; //aMemoField is an array
//Contains memo field broken down into chunks
//of 254 char or less}
SqlStr = SqlStr.Subtring(1,SqlStr.Length-1); //to remove the trailing + sign

SqlStr = SqlStr + " ,interest=" + interest ;
SqlStr = SqlStr + " where id=" + id;

When I execute this, I get an exception, "SQL expression too complex."

I've been struggling with this for 2 days.
Any help is appreciated.

Where is the end of your for loop? Is there more code.

I think that you may want to move the parts the add the "Insert" and "Where" outside of your for loop. It may be causeing duplicates in your final SQL. Not sure because the code seems to be chopped off.