check NEW in insert trigger
Gerd König <[email protected]> Fri, 5 Sep 2003 16:12:13 +0200
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <[email protected]> |
Hi, I'm a little bit confused...(O.K. it's friday ;-)) I've created a after insert trigger, and I want to check one column of the new data set if it is equal to some string. But I cannot manage this... 1.) code: create trigger tr_blub for table1 after insert execute ( VAR company integer; if NEW.comment <> 'default comment' then .... result: NEW.comment is marked RED. General error;-8010 POS(128) Table name must be in from list. 2.) code: if comment <> 'default comment' result: General error;-4024 POS(128) Unknown name:COMMENT so, how to check this value ???? (table1 really has a column named 'comment') thanks in advance ..:GERD:..