Hi Stefan

You Can't use fox Commnands Begin Transaction & End Transaction, Rollback When you are using ADO with CA.

You must use the Connection object for this.

When I create my CA, I add to _screen object the connection object.

So, When I need transctions, I Use :

   _SCREEN.__ObjConn.BeginTrans

.
.
.
.
IF Ok
   _SCREEN.__ObjConn.CommiTrans  
ELSE
   _SCREEN.__ObjConn.RollbackTrans
ENDIF

>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