Which ADO object is used to perform commit / rollback ?
Is it command or connection or recordset

I am not sure of the options given. So please let me know
the answer if it is something else.

Answer Posted / ghanshyam vrema

ye, through Connection object you can commit or rollback
the transaction Eg:

on error go to errhandler
con.BeginTrans

con.execute cmd
con.execute cmd2
con.CommitTrans
errhandler:
con.RollbackTrans

Is This Answer Correct ?    18 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about creating VB applications in excel?

677


___ Property is used to count no. of items in a combobox.

962


How can you Navigate from the DHTML application to another DHTML application? .

1367


What is Parser Bug?

1880


I have several megabytes of memory. Why do I get an "out of memory" error?

1109






What is dao in vb?

509


How would you map properties to controls by using ActiveX Control Interface Wizard?

1713


Explain what is Visual basic?

585


How do I get a bitmap picture in a field in an Access database?

891


what are the Types of LockEdits in RDO?

1674


Is it posible to Create Tables Through Querydef?

1671


1s it posible to Create Tables Through Querydef?

1716


How do I implement an incremental search in list/dir/combo/file boxes?

997


what controls have you used in your project?

1479


Difference between Class Module and Standard Module?

1992