>Is there any way I can append to chat_log without doing an EXTRA SELECT and

>including it with "msg" each time?


I don't think there's a magic way of doing that - the manual says you can't
use LONG in functions. Also, as the column grows, I wonder if this would get
rather slow?

Rather than using a single LONG column per chat, and appending to the end, can
you instead use a separate table per chat, with each "msg" as a row, using VARCHAR?
Should be fast and easy. It would also allow a few other options, like timestamping
each message and so on.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to