|

楼主 |
发表于 2008-4-28 14:50:20
|
显示全部楼层
我新增的三个字段也都有值啊,怎么搞得?下面是触发器的代码
CREATE OR REPLACE TRIGGER "U_ITSMSYS"."HRTABLETR"
AFTER INSERT OR UPDATE OR DELETE ON "U_ITSMSYS"."TPERSON"
FOR EACH ROW
BEGIN
IF INSERTING THEN
INSERT INTO U_HR.TBL_MANPOWERINFO(FGUID,PSNID,Name)
VALUES (:new.FGUID,:new.FID,:new.FDISPLAYNAME);
ELSIF UPDATING THEN
UPDATE U_HR.TBL_MANPOWERINFO SET
FGUID=:new.FGUID,PSNID=:new.FID,Name=:new.FDISPLAYNAME
WHERE FGUID= ld.FGUID;
ELSIF DELETING THEN
DELETE U_HR.TBL_MANPOWERINFO
WHERE FGUID= ld.FGUID;
END IF;
END; |
|