LONG update problem

[Bruce Lowe]

Hi   I've designed some fields in my db using LONGs to store text.  This works fine with inserts however the documentation says I can't update LONGs!!!  Is there some way around this.   I've tried the simplest of queries in the SAP Sql Studio > UPDATE news_item > SET body = 'b2' > WHERE news_item_number = 363   How can one fix this problem, preferably in a generic way ( so I don't have to start putting in too many: if (SAPDB) then {do this update} else {normal update} ).    Kind Regards Bruce