Re: Trigger on same table updates

Bosco Tsang (btsang_at_ctsc.hkbc.hk) wrote:
: 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 |

 =======================================================================/