create tigger tgr_A_insert after insert on A for each row declare _bc int; begin select bc into _bc from B where b.BA=new.AA; update A set ac=_bc where aa=new.aa; end; ----------- select count(*) from B where b.BA=new.AA;有且只有一条记录才行 。
CREATE OR REPLACE TRIGGER custsalegoodsday after insert on custsalegoodsday for each row declare vzkfd int; begin select gmpzkfd into vzkfd from goodsmfprice where GMPMFID=new.mrid and gmpgdid=new.gdid; update custsalegoodsday set custzkfd=vzkfd where gdid=new.gdid; end; 编译时总是提示 GMPMFID=new.mrid and gmpgdid=new.gdid; 未定义
after insert on A
for each row
declare _bc int;
begin
select bc into _bc from B where b.BA=new.AA;
update A set ac=_bc where aa=new.aa;
end;
-----------
select count(*) from B where b.BA=new.AA;有且只有一条记录才行
。
after insert on custsalegoodsday
for each row
declare
vzkfd int;
begin
select gmpzkfd into vzkfd from goodsmfprice where GMPMFID=new.mrid and gmpgdid=new.gdid;
update custsalegoodsday set custzkfd=vzkfd where gdid=new.gdid;
end;
编译时总是提示 GMPMFID=new.mrid and gmpgdid=new.gdid;
未定义