Trigger on same table updates

From: Bosco Tsang <btsang_at_ctsc.hkbc.hk>
Date: 9 Jan 1995 22:26:40 +0800
Message-ID: <3erh30$oeq_at_ctsc.hkbc.hk>


I am trying to use trigger to capture errors in update. I try to check the column value going to be updated if it already existed. I use the after clause in the create trigger statement. But when I do the update, it give a mutation...can't read or write error. What is the correct way to check this column?

--
/=======================================================================

| Bosco Tsang | Department of Geography, Hong Kong Baptist University |
| ´¿¼w¦¨ | ­»´ä®û·|¤j¾Ç¦a²z¾Ç¨t (Chinese Name) |
| 224 Waterloo Road, Kowloon, Hong Kong |
| Phone: (852)2339-7129, (852)2339-7185 (direct) Fax: (852)2338-6005 |
|------------------------------ E-MAILS -------------------------------|
| Campus: btsang_at_ctsc.hkbu.edu.hk GEOG Dept: btsang_at_geog.hkbu.edu.hk |
| CWOL-HKG (Co-SysOp, Geo*): bosco.tsang_at_f29.n700.z6.ftn.air.org |
=======================================================================/
Received on Mon Jan 09 1995 - 15:26:40 CET

Original text of this message