Insert trigger not triggering

Question

question

Mark Anderson asked Mar 1, '10

Insert trigger not triggering

Hi

Got it working - the reconfigure didn't take effect.

I am struggling to get an insert trigger to fire. I have a parent child relationship with an insert into the parent table triggering the insert into the child table. The trigger on the parent table doesn't fire. The data in the parent table is populated from another trigger.

I have currently got nested triggers switch off but have tested with nested triggers on with no effect.

When I manually run the insert statement below, everything is OK and child records created.

PS. I'm still a bit of a noob at this SQL stuff and any help is appreciated. Thanks

trigger insert

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-03-12T06:06:53Z

Hans answered Mar 12, '10

It sounds a bit complicated to me, hard to maintain, hard to debug, triggers firing other triggers. Have you considered building the parent/child record creation into a stored procedure instead of using triggers.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2019-11-11T16:18:14Z

jimsnyder answered Nov 11, '19

@Mark Anderson Put the following code with real names at the beginning of the trigger to see if it is being called. If you get data back, move the query to the end to see if it completed:
INSERT INTO some_table
	some_field
VALUES
	(some text)

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question