>
> Â) ÔÅÐÅÒØ ËÁÓÁÅÍÏ ÄÏËÕÍÅÎÔÏ× É
> Ó×ÑÚÁÎÎÙÈ Ó ÎÉÍÉ ÔÁÂÌÉÃ. ÷ÓÅ ÄÏËÕÍÅÎÔÙ,
> ËÏÔÏÒÙÅ ×ÌÉÑÀÔ ÎÁ ÔÏ×ÁÒÎÙÊ ÚÁÐÁÓ ÉÍÅÀÔ
> ÎÁÂÏÒ ÔÒÉÇÇÅÒÏ×, ËÏÔÏÒÙÅ ÆÉËÓÉÒÕÀÔ ×
> "ÔÁÂÌÉÃÁÈ ÓÏÓÔÏÑÎÉÑ" ÎÅÏÂÈÏÄÉÍÏÓÔØ
> ÐÅÒÅÄÁÞÉ ÜÔÏÇÏ ÄÏËÕÍÅÎÔÁ × ðïãï.
> îÁÐÒÉÍÅÒ ×ÏÔ ÔÁË:
> AS
> begin
> /*ÄÏÂÁ×ÌÅÎÉÅ ÄÏËÕÍÅÎÔÁ × ÓÐÉÓÏË
> ÓÉÎÈÒÏÎÉÚÉÒÕÅÍÙÈ*/
> UPDATE sync$move sm SET sm.time_send = null, sm.time_recv = null
> WHERE sm.pr_key = NEW.move_id;
> IF (row_count = 0) THEN
> BEGIN
> INSERT INTO sync$move (pr_key) VALUES(NEW.move_id);
> END
> end
>
> AS
> begin
> /*ÕÄÁÌÅÎÉÅ ÄÏËÕÍÅÎÔÁ ÉÚ ÓÐÉÓËÁ
> ÓÉÎÈÒÏÎÉÚÉÒÕÅÍÙÈ*/
> DELETE FROM sync$move sm WHERE sm.pr_key = OLD.move_id;
> /*ÄÏÂÁ×ÌÅÎÉÅ ÄÏËÕÍÅÎÔÁ × ÓÐÉÓÏË
> ÕÄÁÌÑÅÍÙÈ*/
> DELETE FROM sync$deleted sd WHERE sd.table_name = 'MOVE' AND
> sd.pr_key = OLD.MOVE_ID;
> INSERT INTO sync$deleted (table_name,pr_key)
> VALUES('MOVE',OLD.move_id);
> end
>
îÕ ÚÁÓÉÎÈÒÏÎÉÚÉÒÏ×ÁÌ ÔÙ ðïæ1 Ó ðïãï, ÎÏ ÐÏÔÏÍ ÜÔÉ ÖÅ ÄÁÎÎÙÅ ÎÁÄÏ ÐÅÒÅÄÁÔØ ×
ðïæ1 É ðïæ2, ËÁË ÜÔÏ ÄÅÌÁÅÛØ?
