>>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