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

What about DLL calls that require callbacks?

985


Types of cursors in DAO?

1486


Which language is used in visual basic?

487


Can you create a tabletype of recordset in Jet connected ODBC dbengine.

1461


Write the Steps in Creating an ActiveX Control?

1972






What is the use of Visual Basic Document file?

1906


What is Mask Edit and why it is used?

1439


How would you access objects created in ActiveX Exe and ActiveX Dll

1516


Draw Sequence Modal of RDO? Explain.

1617


VB ActiveX: Create a "drivelist"(D1) box, a "folderlistbox"(FLD1) that changes whenever D1 is changed , and a "FilelistBox"(FIL1) that is populated with the file lists under the selected directory in (D1).The file selected is stored in a variable "filename" along with the path. Question: How to use this activeX control in VC++ to get the selected filename?

1523


Types of DBCombo boxes

1583


How to find size of the file. Which method or function is used to occomplish this?

1492


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.

1684


Types of LockEdits in RDO.

1702


What is the use of debug Window?

1546