Subject Re: acces on old field value on after delete
Author james_027
> >
> >Iam wondering that are the values of old.field values in the insert
> >event and the values of the new.field values in the delete event. Is
> >it null? If null then the result of the update statement will null
> 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.