Index: trunk/SQL/Triggers/zapisz_do_reklamy.txt
===================================================================
--- trunk/SQL/Triggers/zapisz_do_reklamy.txt (revision 484)
+++ trunk/SQL/Triggers/zapisz_do_reklamy.txt (revision 484)
@@ -0,0 +1,31 @@
+
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+
+ALTER TRIGGER [zapisz_do_reklamy] ON [dbo].[PlatnosciEcard] 
+FOR UPDATE
+AS
+declare @Status bit
+declare @Status_data datetime
+declare @IDFaktury int
+declare @ORDERNUMBER int
+
+select @ORDERNUMBER = ORDERNUMBER, @Status = Status, @Status_data = Status_data, @IDFaktury = IDFaktury from inserted
+if @Status = 1
+
+--update REKLAMA set [Rodzaj potwierdzenia] = 'ECARD', [Symbol potwierdzenia] = @ORDERNUMBER, [Data zap³aty] = @Status_data, Zap³acono = @Status where [ID_Faktury] = @IDfaktury
+
+update dbo.Wplaty set
+ [rodzajPotwierdzenia] = 'ECARD', 
+ [symbolPotwierdzenia] = @ORDERNUMBER, 
+ [dataWplaty] = @Status_data
+ where [idFaktury] = @IDfaktury
+GO
+
+SET ANSI_NULLS OFF
+GO
+SET QUOTED_IDENTIFIER OFF
+GO
+