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
How would you map properties to controls by using ActiveX Control Interface Wizard?
To validate a range of values for a property whenever the property values changes,which type of property procedure you use?
What is shortcut menu and explain "The ole control's shortcut menu".
How can you Add API functions to your Application?
How come I get a "No Current Record" error when I use a a Data Control on an empty table?
What is DDE?
by writing MACRO CODE,i want to retrive data from one spead sheet to another UI (workbook). control will search cell by cell for each row and load the data in another workbook(UI). ex: custdetails custname lastname locaton mobile pincode custdetails raj tony hyd 555555 521245 servcreqrd srvce# srvcename location srvcepincode servcreqrd 754 drilling hyd 521784 for the above example in the another workbook retrive data like this custname Raj srvce# 754 srvcepincode 521784. while retrieving data control will search cell by cell for each row.
Types of cursors in DAO?
How do I program the Novell NetWare API from VB?
How can I speed up my VB database application?
How can you Navigate from the DHTML application to another DHTML application? .
How would you add elements in TreevieW Control.
How would you create properties by using class Builder Wizard?
What are the rules which should be followed while naming a variable in VB?
How would you convert a form into document?