Hi John, as I cannot reproduce that problem (all works fine here), could you please tell which type the 'msg_field' has, and possibly which data is contained in the row that is rejected with that error you have shown?
(I get a (really reasonable) error if the data plus the concatenated string is longer than the column size.) Regards Alexander Schr�der SAP Labs Berlin > -----Original Message----- > From: john doed [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 04, 2003 12:51 PM > To: [EMAIL PROTECTED] > Subject: Cocatenating strings, How with prepared statements? (JBDC) > > > How can I cocatenate a varchar in an UPDATE sql prepared Statement? > > This SQL was working with SAPDB: > UPDATE atable SET msg_field=msg_field & 'my new string' WHERE id=1" > > but now with prepared statements I get an error: > > UPDATE atable SET msg_field=msg_field & ? WHERE id=1" > pstmt.setString(1,"my new string"); > > Gives this error: > SQLException error "Value too large" > > I am using 7.4.3.10 > > Thanks. > > _________________________________________________________________ > Help STOP SPAM with the new MSN 8 and get 2 months FREE* > http://join.msn.com/?page=features/junkmail > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
