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!
**elinore**
---------------------
"The most powerful weapon on earth,
is the human soul on fire" - Ferdinand Foch