问一个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 ; ^

[解决办法]
木有用过