Posted by candide_sh on 07/18/07 08:23

hello,
I googled around some time but I found no solution for this issue
(SS2000).

I have a table tblB which has to be filled whenever in table tblA
records are inserted, updated or deleted.
So I created one trigger which works fine for inserts and updates and
fills my tblB. tblB is filled with other fields which I get from a
view vwC. This view vwC is based on a key field used in tblA.

The issue is about this view. When in tblA a record is deleted, the
corresponding record in vwC does not exist and I can't fill tblB. I
tried around with INSTEAD OF -Trigger and got error message because
tblA has RI cascades so this is not possible. A temp table could be
the right way? Can you show me an example?

thanks
--
candide_sh

• Next in forum: Re: Trigger After Delete - I need a Trigger Before Delete
• Prev in forum: Re: Combining many records into 1
• Thread view: Trigger After Delete - I need a Trigger Before Delete

[Reply to this message]