Subject | Re: acces on old field value on after delete |
---|---|
Author | james_027 |
Post date | 2004-08-29T14:06:11Z |
> Currently, yes. But the behaviour is changed in HEAD so, in the nextrefers to
> version, you will get an exception if your delete trigger code
> the NEW variables or your insert code refers to the OLD.If yes then why is it that the update result is not null? for example
>
if i have this ...
update table
set qty = qty -old.qty + new.qty
in after insert event wherein the old.qty is null.
regards,
james