Hi All!

i'd like to hear some insights on which better method to use for ADO transactions.

i wrote a short procedure that uses the BeginTrans,CommitTrans and RollBackTrans and uses a SQL Statement to perform database manipulation (select,add,update and delete). However my boss asked me to try the procedure using the ADO methods (ado.addnew,ado.update,ado.delete etc) instead of using a straight sql statement.

i personally prefer the first method (using a straight sql statement) but i was asked to differentiate these 2 methods and recommend which is better.

any insight would really help!

Thanks!