The CA Class does not call Begin/End Transaction implicitly, it manages as any transaction in VFP. You should check your transaction level (TXNLEVEL function) since only 5 levels are allowed.



>Hi,
>
>I have three CursorAdapters that use ADO. When I update the changes to the database for these 3 adapters, I want to wrap it in a transaction, so if one of the updates fails, I can rollback to the previous state.
>
>So I used the BeginTrans, CommitTrans and RollbackTrans methods on the ADO COnnection I use for the three ADO Recordsets the CursorAdpters use. But calling BeginTrans generates an error stating I can not create anymore transaction during this session.
>
>It seems like each CursorAdapter internally calls BeginTrans and manages his own transactions. This looks fine, but how can we have a transaction over more than one CursorAdapter?
>
>TIA,
>
>Stefan