Subject | Rollback event on trigger |
---|---|
Author | Adomas Urbanavicius |
Post date | 2005-01-24T01:59:27Z |
Hi,
Is it possiple somehow to rollback edit/delete/insert event on trigger
automatically ?
I can raise ecxeption, but what if I want to do it silently.
Something like
table tb_cutomers
trigger on delete
..... test if customer has some not returned loans ..... then
rollback/cancel
else delete it.
It is possible to do so in App, but some "clever" customers admins can
access raw table via console and write "delete from tb_customers...." :))
Same with edition or insertion.
Adomas
Is it possiple somehow to rollback edit/delete/insert event on trigger
automatically ?
I can raise ecxeption, but what if I want to do it silently.
Something like
table tb_cutomers
trigger on delete
..... test if customer has some not returned loans ..... then
rollback/cancel
else delete it.
It is possible to do so in App, but some "clever" customers admins can
access raw table via console and write "delete from tb_customers...." :))
Same with edition or insertion.
Adomas