transaction

[amilapradeep]

i have to insert one record and update another 2 table. if update is no successful i want rollback inserted transaction. problem is i use one public connection to create connection with db and every time i use that.and use class and it have update and insert function. in this case i don't know how to use transaction object. i use vb 2005. as a example in case i want to add a record i just call classname.addrecord("qry") and classname.update("qry") can anyone help me. regards amila pradeep

[Guffa]

Create overloads for the AddRecord and Update methods that takes a transaction object along with the SQL query. Use the transaction object in the actual database calls in the methods.

--- b { font-weight: normal; }