Trigger for inserts works fine, but the one for updates throws an error since I’m trying to get access to it’s table
I need to make two seperate triggers (it is required to be made that way), one for the inserts and one for the updates on a table contaning different stages of a project which id’s comes from another table. Whenever a project stage is updated, I need to make sure the total budget of the stages of a project isn’t higher than the one of the actual project. Here is the code of the table creation and the one of the triggers.
Trigger for inserts works fine, but the one for updates throws an error since I’m trying to get access to it’s table
I need to make two seperate triggers (it is required to be made that way), one for the inserts and one for the updates on a table contaning different stages of a project which id’s comes from another table. Whenever a project stage is updated, I need to make sure the total budget of the stages of a project isn’t higher than the one of the actual project. Here is the code of the table creation and the one of the triggers.
Trigger for inserts works fine, but the one for updates throws an error since I’m trying to get access to it’s table
I need to make two seperate triggers (it is required to be made that way), one for the inserts and one for the updates on a table contaning different stages of a project which id’s comes from another table. Whenever a project stage is updated, I need to make sure the total budget of the stages of a project isn’t higher than the one of the actual project. Here is the code of the table creation and the one of the triggers.
Trigger for inserts works fine, but the one for updates throws an error since I’m trying to get access to it’s table
I need to make two seperate triggers (it is required to be made that way), one for the inserts and one for the updates on a table contaning different stages of a project which id’s comes from another table. Whenever a project stage is updated, I need to make sure the total budget of the stages of a project isn’t higher than the one of the actual project. Here is the code of the table creation and the one of the triggers.