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:..