>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
>
>
>
>

Great, this is very helpful.