Forum Stats

  • 3,874,180 Users
  • 2,266,677 Discussions


How to avoid Table mutating

I have a table where key members and their roles are stored for a particular project.

For example when a user enters a key member and assign him Project Manager Role, the same key member cannot be a PM Proxy. If I try to do the check in a trigger I will have to select the key members and their roles to make a comparison to see if the same key member is already a project manager. If I do that I will get table mutating error. How can I avoid that and yet make a select on that table?

Your help is greatly appreacitated