On 06.09.2019 15:09, Carlos H. Cantu wrote:
APvFd> Certainly you can repeat search for master record in trigger but IMHO
APvFd> that's not beautiful solution.
Not sure if I understand what you mean with "repeat search for master
record".
if (exists (select * from master where ....))
i.e. repeat what was already done by trigger
The only workaround that I can think of, to not break the business
logic, would be checking rows_affected after the update and if it
zero, raise an exception. This would need to be done in all triggers
with such logic, and I see it as an ugly workaround, not a real
solution.
What I wanted to suggest is even more ugly ;)
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
