Subject ODP: ODP: [firebird-support] trigger not firing?
Author Karol Bieniaszewski

>>The table "sto_depositos" (it means warehouses) is populated entering all the warehouses manually.

>>It barely changes.

 

Then when it is changing you can have situation like this?

 

Transaction 1 start

Transaction 2 start

Tranaction 1 change sto_depositos

Transaction 2 manipulate data and fire that trigger, which do not see modification from Transaction 1 as it is not commited yet.

Transaction 2 commit;

Transaction 1 commit;

 

As you can see, you can loose records…

I do not know if this is in your case..

 

Regards,

Karol Bieniaszewski