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
