[SQLObject] setConnection()

[John B. <bre...@mc...>]

I am trying to change the connection with which a given object is associate for some needed 
transactional behavior.  In an API function a user hands me an SQLObject called xfer.  I want to 
update a value in that object and automically update the value of a row in another table.

To achieve this I created a transaction with

trans = sqlhub.processConnection.transaction()

and then i call xfer.setConnection(trans).

This does not seem to have the effects I assumed so I have a few questions:

1) Is there a better way to achieve the results I am looking for?

2) at what point is an object associated with a DB connection?

3) is it at all possible to change the DB connection associated with a given object?

Any help is greatly appreciated.

Thanks,

John