Member Avatar for drynish

Hello! :)

I have a small issue with an AFTER UPDATE Triger I implemented on one table of my db. In my trigger, I do some validation and update others (not in inserted or deleted) rows of my table. Thoses rows are updated but are not triggering my trigger (similar to a controlled loop). I'm wondering if there's a way to get them running the same trigger.

I have a situation of child / parent in my rows sometimes. If I'm updating a child, I need the parent to be updated and validated. A child is not very at all and I really needs the parent to be the one who makes the "call".

Is it feasible?

Thanks

  • 2 Contributors
  • 2 Replies
  • 114 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by drynish

Recommended Answers

All 2 Replies

Member Avatar for urtrivedi

Please post the exact case with table structure and trigger code.

Member Avatar for drynish

Please post the exact case with table structure and trigger code.

I found the issue, I needed to add a recursive triggers options in Database option which is defaulted to false.

I spend a lot time finding that info and honestly it's a normal comportement to eliminate the risk of endless looping.

I hope it's clear for anyone searching for that kind of issue.

The info is here: http://msdn.microsoft.com/en-us/library/aa258254(SQL.80).aspx

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.