Code:
SET TERM ^ ;
CREATE OR ALTER TRIGGER RM_DNEVNIK_BI FOR RM_DNEVNIK
ACTIVE BEFORE INSERT POSITION 0
as
declare variable tmp_ID INTEGER;
declare variable tmp_carinska_stopa_id INTEGER;
begin
if (new.id is null) then
new.id = gen_id(gen_RM_DNEVNIK_id,1);
execute procedure p_pronadji_id_tarife(new.zaglavlje_id,new.artikal_id,1)
returning_values :tmp_ID;
new.tarifa_id = :tmp_ID;
new.tarifa_ulaz_id = :tmp_ID;
tmp_carinska_stopa_id = 0;
execute procedure p_pronadji_id_carinske_stope(new.zaglavlje_id,new.artikal_id,1)
returning_values :tmp_carinska_stopa_id;
new.carinska_stopa_id = :tmp_carinska_stopa_id;
end
^
SET TERM ; ^
Server Version: WI-V2.5.0.26074 Firebird 2.5