Subject | ODP: ODP: [firebird-support] trigger not firing? |
---|---|
Author | Karol Bieniaszewski |
Post date | 2018-09-25T17:18:05Z |
>>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