var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: OleDB Error updating FoxPro Memo field
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 + "', " +
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.