|Subject||Re: acces on old field value on after delete|
> >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
> 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 ...
set qty = qty -old.qty + new.qty
in after insert event wherein the old.qty is null.