Milan Babuskov wrote:

> BTW, I'm not 100% sure I understand where the problem occurs. Do you use
> persistant connections or something like that?

ADOdb!
Someone had simply disabled transactions altogether to get things to work ;)
This has a StartTrans() and CompleteTrans() which work very nicely in
wrapping the transaction (and 'emulating' transactions where the
database does not support them), and switching the query to use the
transactionID. In fact everything works nicely - except that the
original default Transaction does not see any changes made in the inner
transactions.
I have a fix for the immediate problem, which is just to read the new
data before completing the transaction, but it seems that there IS
something missing by way of a 'Refresh', which I can emulate by closing
and re-opening the connection :(

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