Post reply

Delete After Trigger

  • July 6, 2011 at 12:24 pm

    #1349222

    GilaMonster (7/6/2011)

    toddasd (7/6/2011)

    GilaMonster (7/6/2011)

    There are no other triggers on either table? Absolutely sure of that?

    Exactly. There has to be an INSTEAD OF INSERT trigger on the archive table. Lowell and I have independantly replicated your tables and trigger and it works as expected.

    EDIT: oops, INSTEAD OF INSERT on the archive table, or INSTEAD OF DELETE on the base table.

    Or an AFTER INSERT on the archive table.

    One of the most messed up things I've seen with triggers was an AFTER INSERT trigger on a table that inserted the rows into a different table and then deleted the just-inserted rows. No matter what was inserted the table was empty. Took quite some time to figure that one out.

    Yep, nasty work. PITA to troubleshoot multiple triggers not to mention with re-entrant is turned on.

    ______________________________________________________________________________
    How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply