reset password
Author Message
HuanXue
Posts: 34
Posted 15:20 Oct 20, 2010 |

For example,5.6 b), we can create a trigger to forbid insert a enrollment.

But if someone enrolls another course and then update it to 'Topology', this trigger doesn't work.

We need two triggers or have someway to forbid insert & update in one trigger?

cysun
Posts: 2935
Posted 15:24 Oct 20, 2010 |

You can specify multiple triggering events for a trigger, e.g.

create trigger some_trigger after insert or udpdate or delete on some table ...