Subject | Re: [firebird-support] Re: Firebird-2.0.0.12748-0-Win32.exe Problem |
---|---|
Author | Ivan Prenosil |
Post date | 2006-12-11T22:01:52Z |
> CREATE TRIGGER UPDATEPROPID_IMPROVEMENTHEADER FOR IMPROVEMENTHEADER...
> ACTIVE
> AFTER UPDATE POSITION 5
> AS
> EXECUTE PROCEDURE CheckAsmtCode NEW.AsmtCode1,You are assiging value into NEW.AsmtCode1 in AFTER UPDATE trigger which is forbidden in FB2.
> NEW.PropID, NEW.ImprType_Code, NULL, 1 RETURNING_VALUES NEW.AsmtCode1;
Ivan