Naomi,

Glad it was. =)

Dennis

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