Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-21 : 10:10:13
|
| govind writes "hi we are developing one banking application. we are using SQL server as back end and com component as middle tier. can i call three procedures with in a single method of a component with same transaction. can i roll back or commit the entier transaction. mymethod(param1,param2){ begin transaction call SQLprocedure1(OUT p1) if (p1=0) then call SQLprocedure2(OUT pp2)} if something goes wrong i should be able to roll back the entier transaction thanksvg rajan" |
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2002-01-21 : 10:32:57
|
| If you call either SetComplete or SetAbort method of the Object Context at the end of your COM method, the transaction will either be completely committed or rolled back. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-01-21 : 15:17:25
|
| Above should work if you are using mts and letting it control transactions.Otherwise you can create a transaction on the connection by just sending a begin tran command to the server.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
com vs SQL