long fields in trigger
"Jens Stier" <[email protected]> Tue, 9 Sep 2003 16:39:37 +0200
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <[email protected]> |
Hi, i have the following two tables: CREATE TABLE "TBLARTIKEL" ( "ID" Integer, "BEZEICHNUNG" Varchar (50), "BILD" Long BYTE ) CREATE TABLE "TBLARTIKEL2" ( "BEZEICHNUNG" Varchar (50), "BILD" Long BYTE ) now i want to create a trigger that inserts a new row to tblartikel2 each time tblartikel is updated: CREATE TRIGGER artikelupdate FOR TBLARTIKEL AFTER UPDATE EXECUTE ( INSERT INTO "DBA".ARTIKEL2(BEZEICHNUNG,BILD) VALUES(:NEW.BEZEICHNUNG,:NEW.BILD); ) if i don't save anything to the field "BILD" everything works fine. but if anything is written to "BILD" I get the error message: GENERAL ERROR;-3102 Is there any problem with long byte fields in triggers? how can i do this then?? thanks J