Information générale
Titre:
CursorAdapters, ADO and Transactions
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement