问一个FireBird触发器的有关问题,关于得到某个字段的编码
问一个FireBird触发器的问题,关于得到某个字段的编码
A
autoid,bautoid,bid,bname,.....
B
autoid,id,name
SET TERM ^ ;
CREATE OR ALTER TRIGGER A_BI0 FOR A
ACTIVE BEFORE INSERT POSITION 0
AS
begin
/* Trigger text */
if (new.autoid IS null) then
new.autoid=GEN_UUID();
if (new.bautoid is null then
这里我想得到B表中的autoid值(唯一)赋给new.bautoid
where new.bid=B.id
and new.bname=B.name);
end
^
怎么写,非常感谢。
SET TERM ; ^
------解决方案--------------------
木有用过
A
autoid,bautoid,bid,bname,.....
B
autoid,id,name
SET TERM ^ ;
CREATE OR ALTER TRIGGER A_BI0 FOR A
ACTIVE BEFORE INSERT POSITION 0
AS
begin
/* Trigger text */
if (new.autoid IS null) then
new.autoid=GEN_UUID();
if (new.bautoid is null then
这里我想得到B表中的autoid值(唯一)赋给new.bautoid
where new.bid=B.id
and new.bname=B.name);
end
^
怎么写,非常感谢。
SET TERM ; ^
------解决方案--------------------
木有用过