Posted by candide_sh on 07/17/07 15:04

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 another 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.

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 would need a Trigger Before Delete
• Prev in forum: database information report
• Thread view: Trigger After Delete - I would need a Trigger Before Delete

[Reply to this message]