Naomi,

>I understand the pcinciple, but if you can post the code of your subclass, it will be most helpful.

I am in a public computer now, but my codes goes something like this...

In my DE subclass, I have the following methods: BeginTrans(), CommitTrans(), RollBackTrans(), SaveTrans().

BeginTrans()
= SQLEXEC( This.DataSource, "BEGIN TRANSACTION" )

CommitTrans()
= SQLEXEC( This.DataSource, "COMMIT" )

RollbackTrans()
= SQLEXEC( This.DataSource, "ROLLBACK" )

SaveTrans()
* loop thru each CA object 
* dump into a Collection oCursors

llCommit = .T.

FOR EACH loCursor IN oCursors
   IF NOT loCursor.Save()
       llCommit = .F.
   ENDIF
ENDFOR

IF llCommit
    This.CommitTrans()
ELSE
   This.RollBackTrans()
ENDIF

HTH,

Dennis