| Subject | Re: Problem with before insert trigger defaults and insert statements |
|---|---|
| Author | Adam |
| Post date | 2005-09-28T00:44:30Z |
Oops, should read as below
> if (new.field2 IS NULL) then
> begin
> if (:VDEF1 IS NULL) then
> begin
> NEW.FIELD2 =0;
> end
> else
> begin
> NEW.FIELD2 =:VDEF1;
> end
> end