Jump to content
  • 0
Sign in to follow this  
Glitch

Trigger Error

Question

I receive an error when trying to enable the new trigger that I am currently working on. The error says "Can not enable trigger due to 2 cascading triggers". 

 

I don't see anything wrong with my trigger, I'm just passing the records to another table from #inserted. 

 

Can someone help?

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hi @Glitch,

 

This error occurs when you exceed the limit of 2 cascading triggers. Caspio's cascading triggers is only limited to 2.

Now, what are cascading triggers? 

This is when, a triggers action activates another trigger.

So for example,

Table A has trigger 1 > The trigger is to Update Table B.

Table B has trigger 2 > Trigger 2 runs on UPDATE, then again activates another trigger.

Now these are cascading triggers. These acts as a waterfall trigger. 

 


I think this error may also happen when you are trying to create triggers on the same event.

Say, the events are - Insert records to table1 upon Insert on table2 . And you have another trigger that would insert records to Table2 as well.

You can view the triggers associated on the Table by clicking Properties under the Tablename.

 

Screenshot_13.png.bf04fabd8ead37032fe63748e69fddfe.png

  From there, you can check which of the Triggers are causing the conflict. 

 

Hope this helps!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...