Jason Wharton wrote:

> Triggers always fire in conjunction with the insert, update or delete and to
> my knowledge there are no triggers that fire upon commit. However, the
> changes invoked by the triggers are subject to the transaction.

Forget what I said ;)
I'd pulled an all nighter to finish a major update and was not thinking
straight :(
Visibility of the results was more what I was thinking about, but of
cause the 'instigator' can see that within the transaction.
I tend to keep things tight so that transactions are not held over
longer than necessary using things like cached updates in IBO.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services