Jump to content
  • 0

Trigger record limit


Shiro

Question

3 answers to this question

Recommended Posts

  • 0

Depending on How complicated the trigger is, if its a very simple workflow where the only challenge or issue is the exceeding records, perhaps we can actually use the task workaround and trigger it via cascading trigger.

For example, on main table, you have a trigger that will copy delete all values from table c and insert all records from table b there. Table b however has 15k records.

What we can do is kindof like this, first block is the delete block for table c

2nd block is for inserting all records from table b where autnumber is less than 9k

3rd block is where we insert a single dummy record to a dummy table.

save the trigger and enable.

on the dummy table, create an insert trigger there where it will continue the copying process of the first trigger.

Create an insert block there that will insert all records on table b to table c where autonumber is greater than 9k but less than 15k

save the trigger.

This is the idea. It may (and it will) get more complicated as your trigger becomes more complicated as well. 

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...
×
×
  • Create New...