Forum Replies Created

Viewing 3 posts - 1 through 4 (of 4 total)

  • RE: Help with Triggers

    Dird (4/20/2013)

    Yeah I just tested it in my env 😮

    Also the commit shouldn't be within the transaction but I guess you copied it before I added it in~

    Dird

    Should I...

    April 20, 2013 at 5:34 pm

    #1608516

  • RE: Help with Triggers

    Dird (4/20/2013)

    It's hard to say without knowing more about the customer_rentals DDL. Would the rentals table even be updated or only insert/delete? Maybe something like this?

    CREATE TRIGGER dbo.tr_num_rented_update

    ON dbo.customer_rentals FOR...

    April 20, 2013 at 5:18 pm

    #1608514

  • RE: Help with Triggers

    Dird (4/20/2013)

    I haven't done any T-SQL myself but shouldn't you be calling the "deleted" MRT instead of "inserted"? In pl/sql I'd be calling :OLD instead of :NEW.

    Dird

    Thanks that was it.

    Moving...

    April 20, 2013 at 4:50 pm

    #1608509

Viewing 3 posts - 1 through 4 (of 4 total)