Rollback using ADO.Recordset!
Posted on 2002-04-15
I use ADO to add/update/delete record to my Oracle DB.
In using a recrodset's method --> AddNew, Update.
Do I need to do a rollback if the AddNew, Update fails?
If yes, how can I do this?
I found there exists a rollback method at the conneciton object, but not at recordset object.
My table at oralce db contains a field which is of type BLOB.
I only know how to use the recordset object to add record to this table which will add a binary file to the database.
In my case, how can I do a rollback if the operation fails?
Thanks for your advice!