Re: ODP: ODP: [firebird-support] trigger not firing?

2018-09-25 Thread shg_siste...@yahoo.com.ar [firebird-support] 
Nope... :(  

 So, do you think that no database corruption can make this to happen?
 

 I have two options here: the former... or I have a very hidden bug which I 
didn't found yet which is deleting those missing records... just in case, I 
created an "after delete" trigger to log any possible deletion... will see...
 

 Sergio

ODP: ODP: [firebird-support] trigger not firing?

2018-09-25 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] 
>>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