Hi Edward,

>Merry Xmas Hugh

Merry Christmas to you!!!

>using mySql, there are no problems on varchar or SqlServer on Text field
>only in VFP memo field where memoString is longer than 255 chars

255 is the max length of a text field in VFP. I wonder if there are some problems with field mapping. You might try to concatenate 2 form textbox values together to create a string longer than 255 chars and then post them to the VFP memofield to see if the problem is on the HTML form end or the SQL statement end.

My bet is that it has something to do with the SQL statement.

Here's where I'd look: "PreparedStatement stmt = conn.prepareStatement(sqlFieldDescription);"

Now I'm intrigued!

Hugh