ADO BeginTrans, CommitTrans, and RollbackTrans Methods

## ADO Tutorial

ADO HOME ADO Intro ADO Connect ADO Recordset ADO Display ADO Query ADO Sort ADO Add ADO Update ADO Delete ADO Demo ADO Speed Up

## ADO Objects

ADO Command ADO Connection ADO Error ADO Field ADO Parameter ADO Property ADO Record ADO Recordset ADO Stream ADO DataTypes
ADO Summary

## ADO Examples

ADO Examples

# ADO BeginTrans, CommitTrans, and RollbackTrans Methods

Complete Connection Object Reference

These 3 methods is used with the Connection object to save or cancel changes made to the data source.

Note: Not all providers support transactions.

Note: These 3 methods are not available on a client-side Connection object.

### BeginTrans

The BeginTrans method starts a new transaction.

This method can also be used to return a long value that is the level of nested transactions. A top level transaction has a return value of 1. Each additional level increments by one.

### CommitTrans

The CommitTrans method saves all changes made since the last BeginTrans method call, and ends the current transaction.

Since transactions can be nested, all lower-level transactions must be resolved before you can resolve higher-level transactions.

### RollbackTrans

The RollbackTrans method cancels all changes made since the last BeginTrans method call, and ends the transaction.

Since transactions can be nested, all lower-level transactions must be resolved before you can resolve higher-level transactions.

### Syntax

level=objconn.BeginTrans()
objconn.BeginTrans
objconn.CommitTrans
objconn.RollbackTrans

Complete Connection Object Reference

## Your suggestion:

Your E-mail (optional):

Page address:

Description:

Close [X]

## Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

## WEB HOSTING

Best Web Hosting UK Reseller Hosting Wow! $5 SSD Hosting

## WEB BUILDING

Download XML Editor
FREE Website BUILDER FREE Website Creator

## WEB RESOURCES

Web Statistics Web Validation

## SHARE THIS PAGE