Subject | Re: Cross database update |
---|---|
Author | |
Post date | 2014-11-18T17:30:03Z |
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
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