Chip 2000 May/Chip_2000-05_cd1.bin/tema/SW602/Winbase/EShop_demo/AKTUALIZACE_OP.TRG

Text File | 2000-03-16 | 457b | 10 lines

{$$3219639419 .                              }TRIGGER `aktualizace_OP` AFTER UPDATE  ON `Obchodni_partneri`
REFERENCING OLD AS `OLD` NEW AS `NEW`
FOR EACH ROW
begin
// call log_write("aktualizace OP");
 if (old.PSC<>new.PSC) OR (old.mesto<>new.mesto) OR (old.ulice<>new.ulice) OR (old.kont_osoba<>new.kont_osoba) OR (old.mail_adres<>new.mail_adres) OR (old.telef<>new.telef)OR (old.intr_pswd<>new.intr_pswd) then
 SET new.dat_act=now;
 end if;
end