RollBack vs. Commit 
Author Message
 RollBack vs. Commit

If you issue a BeginTrans on an ADO connection object but make no
changes, should you do a RollBack or a Commit before closing the
connection?

      - Jim

Sent via Deja.com http://www.*-*-*.com/
Before you buy.



Fri, 14 Jun 2002 03:00:00 GMT  
 RollBack vs. Commit
Do a a rollback.
Quote:

> If you issue a BeginTrans on an ADO connection object but make no
> changes, should you do a RollBack or a Commit before closing the
> connection?

>       - Jim

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Fri, 21 Jun 2002 03:00:00 GMT  
 RollBack vs. Commit
Thanks, that's what I've decided to do.  - Jim



Quote:
> Do a a rollback.


> > If you issue a BeginTrans on an ADO connection object but make no
> > changes, should you do a RollBack or a Commit before closing the
> > connection?

> >       - Jim

> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

Sent via Deja.com http://www.deja.com/
Before you buy.


Sat, 22 Jun 2002 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Oracle commits vs Sybase/SQL-Server commits

2. workspace commit/rollback

3. Commit/Rollback spanning procedures

4. DB Commit\Rollback Issues

5. Begin-Rollback-Commit Transaction

6. How does .commit and .rollback work?

7. VB4 - Commit or Rollback without BeginTrans. (Error 3034)

8. Commit and Rollback

9. Using commit/rollback with Oracle and RDO

10. BeginTrans Commit RollBack

11. BeginTrans, Commit, RollBack

12. Rollback and Commit with more than 1 form open in VB3

 

 
Powered by phpBB® Forum Software