Subject Re: [ib-support] Auditing updates
Author Jason Chapman (JAC2)
>
> IF (OLD.mast_Column_Name IS NULL OR
> NEW.mast_Column_Name IS NULL) THEN
I don't understand this line

>
> BEGIN
>
> IF ((OLD.mast_Column_Name IS NULL AND
> NEW.mast_Column_Name IS NOT NULL) OR
> (OLD.mast_Column_Name IS NOT NULL AND
> NEW.mast_Column_Name IS NULL)) THEN
>
> EXECUTE PROCEDURE Audit_The_Change(parameters, ...);
>
> END
>
> ELSE IF (OLD.mast_Column_Name <> NEW.mast_Column_Name) THEN
>
> EXECUTE PROCEDURE Audit_The_Change(parameters, ...);
>
>
Slightly better is

if (old.fld is null and new.fld is not null) or
(old.fld is not null and new.fld is null) or
(old.fld <> new.fld) then
begin
EXECUTE PROCEDURE Audit_The_Change(parameters, ...);
end

still could do with an operator:
A equalAssessNull B

JAC.