What I recognized right now is that the statement only fails for insert trigger. Update trigger seem to work.
What's the reason? Hope, somebody can reduce my confusion! -----Original Message----- From: Stoedtler, Mathias [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 9:20 AM To: [EMAIL PROTECTED] Subject: Trigger question Hello, The statement gives an error? Why? What to do? Which from list? create trigger testtrigger for t2 after insert, update execute ( if(New.t1_id =null) then stop(37892493,'a message'); ) ---- Error ------------------------------- Auto Commit: On, SQL Mode: Oracle, Isolation Level: Committed General error;-8010 POS(78) Table name must be in from list. - if(New.t1_id is not null) also does not work - even New.t1_id <> old.t1_id does not work (from the example in the documentation) Greets Mathias -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
