DDL Code |
CREATE TRIGGER [BP_UTrig] ON [dbo].[vpBillPayments] FOR UPDATE AS
SET NOCOUNT ON
IF UPDATE ("Reference")
BEGIN
UPDATE "vpBillPaymentDetails"
SET "vpBillPaymentDetails"."Reference" = inserted ."Reference"
FROM "vpBillPaymentDetails", deleted , inserted
WHERE deleted ."Reference" = "vpBillPaymentDetails"."Reference"
END
|