Re: ADO and MetaData


"Vitali Kalinin" wrote
If I am understand you correctly you are doing this:
1. Start tran
2. Populate SQL
3. Fill params
4. Execute query
5. Commit Tran
And yours sp doing rollback if it is called with empty params (which IMHO
is wrong).
If this is the case I am suggecting you to rearrange logic like this:
1. Populate SQL
2. Fill params
3. Start tran
4. Execute query
5. Commit Tran

My sp's are not written to rollback if they have empty parameters. It is
just that the inserts and updates are not happening. I will investigate the
start tran and commit tran placings as you suggested.


.

Relevant Pages

  • Re: Help with Trasaction Commiting/Rollback
    ... declare @err int, @rows int ... > This is my first Transaction and would like to know if I am on the ... > ROLLBACK TRANSACTION ...
    (microsoft.public.sqlserver.programming)
  • PROBLEM WITH TRANSACTIONS
    ... The front will call the SPs tru a component. ... COMMIT TRAN(coded in .Net). ... calls another SP (inner level), and the rollback comes from that inner level ...
    (microsoft.public.sqlserver.programming)
  • how to roll back
    ... is this the only way to do a rollback in SQL2000? ... Use Query Analyzer, BEGIN TRAN ... COMMIT TRAN, then ROLLBACK TRAN to ... undo the changes. ...
    (microsoft.public.sqlserver.server)