Hi"tx2 inserts a detail record in TableB Trigger on TableB tries to update
master record, since the record is still not visible for this snapshot,
update has null effect"I do not understand this point. If table B i detail it
can only insert record for visible to it record in master. Or do you in your
trigger you update whole table master not only master record of this detail?If
you update whole table, than you have hole in your bussiness logic, as you must
run same update not only in triggers on detail but also in triggers on master
table.This can cause same deadlocks but prevent inconsistent data.Regards,Karol
Bieniaszewski
null
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
