Re: Transaction Problem, part two..
- From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
- Date: Fri, 17 Nov 2006 20:09:59 -0600
Because this is a procedure that is called from a master procedure that does
something like this:
try
MyAdo.begintrans;
UpdateOrdersShipDate(thisorder, ThisSubOrder, Now);
AnotherRoutine;
AndAThird;
MyAdo.CommitTrans;
except
MyAdo.RollbackTrans;
end;
Maybe I didn't understand this, but if I don't re-raise the exception in the
UpdateOrdersShipDate procedure, wouldn't it not be caught in the Except from
this master procedure?
Your RASIED exception should trigger a Rollback here at which point any error
message will be suppressed by this Try block
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.
- References:
- Transaction Problem, part two..
- From: John Friel
- Re: Transaction Problem, part two..
- From: Brian Hollister
- Re: Transaction Problem, part two..
- From: John Friel
- Transaction Problem, part two..
- Prev by Date: trouble creating DSN
- Next by Date: Re: Transaction Problem, part two..
- Previous by thread: Re: Transaction Problem, part two..
- Next by thread: Re: Transaction Problem, part two..
- Index(es):
Relevant Pages
|