Hello, sorry, but the database kernel doesn't support appending long columns. I think using VARCHAR columns instead of one long column like recommended by Richard Barrington (see his mail in the list) is a good idea to solve your problem.
Regards, Marco ---------------------------------------------- Marco PASKAMP SAP DB, SAP Labs Berlin > -----Original Message----- > From: john doed [mailto:[EMAIL PROTECTED]] > Sent: Donnerstag, 13. Februar 2003 05:12 > To: [EMAIL PROTECTED] > Subject: Cannot append strings to LONG column in JDBC, > assistance please > > > When trying to append (concatenate)to a LONG column I get the > following > error: > [-7032] (at 39): SQL statement not allowed for column of data > type LONG > > sql = "UPDATE CHAT_TRANSCRIPTS SET chat_log= chat_log & ? > WHERE chat_id=?"; > > pstmnt = con.prepareStatement(sql); > pstmnt.clearParameters(); > pstmnt.setString(1, msg); > pstmnt.setString(2, chatID); > pstmnt.executeUpdate(); > > Is there any way I can append to chat_log without doing an > EXTRA SELECT and > including it with "msg" each time? > > thanks > > > > > _________________________________________________________________ > Tired of spam? Get advanced junk mail protection with MSN 8. > 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
