AW: check NEW in insert trigger

Hi Walter and rest of the list,

sorry that I forgot to mention this in my last posting, I already
tested your version and this produces the error:

General error;-7045 POS(243) Parameter spec not allowed

so, I have no idea how to check this NEW value in my insert trigger.
Following code is not working, but how ???

1.)
create trigger tr_blub for table1 after insert execute
 (
 	if NEW.comment <> 'default comment' then
	...
 )
2.)
create trigger tr_blub for table1 after insert execute
 (
 	if :NEW.comment <> 'default comment' then
	...
 )
3.)
create trigger tr_blub for table1 after insert execute
 (
 	if comment <> 'default comment' then
	...
 )


thanks in advance ..:GERD:..






-----Ursprüngliche Nachricht-----
Von: Walter Link [mailto:[email protected]]
Gesendet: Freitag, 5. September 2003 19:07
An: Gerd König
Betreff: Re: check NEW in insert trigger


Hallo Herr König,

Sie sollten den Doppelpunkt vor dem NEW nicht vergessen:

if :New.comment <> ...


Am Freitag, 5. September 2003 16:12 schrieb Gerd König:
> 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:..
>
>
> _______________________________________________
> sapdb.general mailing list
> [email protected]
> http://listserv.sap.com/mailman/listinfo/sapdb.general