iBase.ru Forum

Код: Выделить всё

ALTER TRIGGER provodka_bi0
active before insert position 0
AS
DECLARE VARIABLE t integer;
begin
  t=(select KOL_VO from new_table where new_table.id_tovara=id_tovara);

  if(new.kol<=t)
then
begin
POST_EVENT 'NEW_ORDER';
end
end

Код: Выделить всё

t=(select KOL_VO from new_table where new_table.id_tovara=id_tovara)

Код: Выделить всё

select new_table.id_tovara from new_table where new_table.id_tovara=new.id_tovara into t;

Код: Выделить всё

CREATE trigger provodka_bi0 for provodka
active before insert position 0
AS
DECLARE VARIABLE tres integer;
begin
select new_table.kol_vo from new_table where new_table.id_tovara=id_tovara into tres;
if(new.kol<tres)then
update new_table set new_table.kol_vo=(tres-new.kol) where new_table.id_tovara=id_tovara;
end