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
What about DLL calls that require callbacks?
Types of cursors in DAO?
Which language is used in visual basic?
Can you create a tabletype of recordset in Jet connected ODBC dbengine.
Write the Steps in Creating an ActiveX Control?
What is the use of Visual Basic Document file?
What is Mask Edit and why it is used?
How would you access objects created in ActiveX Exe and ActiveX Dll
Draw Sequence Modal of RDO? Explain.
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?
Types of DBCombo boxes
How to find size of the file. Which method or function is used to occomplish this?
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 LockEdits in RDO.
What is the use of debug Window?