iBase.ru Forum

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

CREATE OR ALTER trigger table_ai0 for table
active before insert position 1
as
declare variable table_id  integer;
declare variable from_date  date;
begin
  select c from table where table.thing_id = new.thing_id
  and new.from_date between table.from_date and table.to_date into :table_id;
  update table set table.to_date = new.from_date-1 ,table.next_id = new.c
   where c = :table_id;
   if (exists (select c from table where table.thing_id = new.reating_orders_all_id
   and table.to_date <= new.from_date-1 )) then


end

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

CREATE OR ALTER trigger table_bu0 for table
active before update position 0
AS
  declare variable table_id  integer;
begin
  if (new.to_date <> old.to_date) then



begin
  select c from table where table.thing_id = new.thing_id
  and new.to_date+1 between table.from_date and table.to_date into :table_id;


  update table set table.to_date =

  (select from_date-1 from table where from_date < new.to_date)

  where c = :table_id;
end
end