Subject Re: acces on old field value on after delete
Author james_027
> Currently, yes. But the behaviour is changed in HEAD so, in the next
> version, you will get an exception if your delete trigger code
refers to
> 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