Hi Sean I think not. When you look at it, the two tables could also be located in one db ad then the for select update loop should point to the same topic/question.
How can I do this without using a block in the update part which sets the transaction property correctly but runs isolated apart from the parameters and when I use two different statements, the rdb$set has no effect and the triggers fire. So I think that IBExpert just juggles the connections and everything else is pure firebird. Kind regards Christian
