>>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.
HTML : JSP
<textarea class="td" rows=15 name="notes" cols=93><%=notes%></textarea></td></tr></table>
>
>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!
>
JAVA/JSP
String notes = request.getParameter("notes");
String sql = "UPDATE messages SET notes=? WHERE ctrl_no=1"; ( first record )
stmt = conn.prepareStatement(sql);
stmt.setString(1,notes)
stmt.executeUpdate();
works fine with mySql & SQLServer where messages.notes is memofield in VFP and varchar in mySql & text in SQLServer ( same routine used on 3 database platform / depends on client's preference )
in VFP keeps truncating to 255 char ( no problem if messages.notes is C(255) )
Happy New Year Hugh for being intrigued !!
I appreciate it because i'm trying to keep VFP alive for its powerful data engine and royalty free distribution
( wont drop it for SQLServer but has to if Memo field does not work out )
Ed
Use things, not people. Love people, not things