CREATE TRIGGER YourTrigger ON OrderRebateHistory
INSTEAD OF INSERT
AS
BEGIN
IF NOT EXISTS
(SELECT * FROM oelinhst o
INNER JOIN INSERTED i
ON i.ordtype = o.ordtype
AND i.ord_no=o.ord_no
and i.line_seq_no=o.line_seq_no)
BEGIN
INSERT INTO OrderRebateHistory
SELECT * FROM INSERTED
END
END

quote:

---

Originally posted by Vack

Still have the same problem. It is writing the record to the OrderRebateHistory and removing the record that was in the table.

Example: I delete order 89 from the orderline table which writes a record to the OrderRebateHistory.
Then I enter another order 90 and delete it. After deleting it, order 89 is removed from the OrderRebateHistory table and order 90 gets written.

---

quote:

---

Originally posted by Vack

YES IT IS SET

---

quote:

---

Originally posted by Vack

The trigger is actually on the orderrebate table. When a record is deleted from it I want it to go to the history.

CREATE TRIGGER [UPDATEOrderRebateHistory] ON [dbo].[OrderRebate]
for delete
as

update OrderRebateHistory
set ord_type = deleted.ord_type,
ord_no = deleted.ord_no,
line_seq_no = deleted.line_seq_no,
status = deleted.status,
item_no = deleted.item_no,
price = deleted.price,
rebate_amt = deleted.rebate_amt,
ext_rebate = deleted.ext_rebate,
rebate_pct = deleted.rebate_pct,
qty_ordered = deleted.qty_ordered,
qty_to_ship = deleted.qty_to_ship,
cus_no = deleted.cus_no,
AccountTypeCode = deleted.AccountTypeCode,
cd_tp = deleted.cd_tp,
A4ID = deleted.A4ID
FROM deleted

---

CREATE TRIGGER YourTrigger ON OrderRebateHistory
INSTEAD OF INSERT UPDATE
AS
BEGIN
IF NOT EXISTS
(SELECT * FROM oelinhst o
INNER JOIN INSERTED i
ON i.ordtype = o.ordtype
AND i.ord_no=o.ord_no
and i.line_seq_no=o.line_seq_no)
BEGIN
INSERT INTO OrderRebateHistory
SELECT * FROM INSERTED
END
END