ADO and rollbacktrans, committrans, begintrans

From: . (ennioennioennio_at_tiscali.it)
Date: 03/16/05 

Date: 16 Mar 2005 09:28:27 -0800

I am using the begintrans, committrans and rollbacktrans methods of
the connection object.

i do a .begintrans, I open a adodb.recorset1 and then i add some
records.
Now, if i open a adodb.recordset2 on the same connection, i can't see
the new added records unless i .committrans, but i don't want to. How
can i do that? How can i see added records in a uncommitted
transaction?

i need to give to the user the ability to .rollbacktrans at the end of
many operations, but i need to do some joins, among these different
operations, that involve records added by the user, i don't know how
to do. Please help me, thanks.

Relevant Pages

  • Re: ADO and DELETE Statement
    ... CommitTrans, and RollbackTrans methods. ... delete fails, you should be able to trap that. ... I am doing this in Navision using the MS ActiveX ...
    (microsoft.public.data.ado)
  • BeginTrans
    ... I'm rewriting VB6 application working with DAO Access 2000 into SQL Server ... If I replace those calls with BeginTrans, CommitTrans and RollbackTrans ... I tried to find some info about BeginTrans, CommitTrans and RollbackTrans ...
    (microsoft.public.sqlserver.programming)
  • Re: Ado.begintrans locks the whole table instead of ROW
    ... >Im using ADO's connection object to BEGINTRANS, COMMITTRANS, ROLLBACKTRANS ... >I get a lock timeout because the whole TABLE is being locked not the new ... but only return the uncommited rows? ...
    (microsoft.public.vb.syntax)
  • Re: beginTrans without commitTrans or rollbackTrans
    ... >what if there's beginTrans without commitTrans or rollbackTrans? ... Also, if that same connetion is used again, and you attempt ...
    (microsoft.public.vb.general.discussion)
  • Re: 440 Automatisierungsfehler
    ... Mache ganz zu Beginn ein BeginTrans und will am ende einen Committrans oder einen Rollbacktrans machen. ...
    (microsoft.public.de.vb.datenbank)