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
Answer by jimsnyder ·
@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)