> 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

hmmm, ezSQL doesn't have this problem :-)
Alan