Transaction Puzzle for you Problem for me. :-) 1

[Deadline]

Hi
My process goes something like this

Start->Fetch from Table-> Send Email to records in the table -> Update a field in the table with the email sent time&date->Update a Log(text file)->End


Is there anyway I can have this entire process as a single transaction ? I mean if 1 fails, everything else fails.





Thank you very much.

RR

 

[jmarler]

Not everything . . . After all, once the emails sent, its sent. You can programmatically update a text file log, but it would probably be better to use a DB table for the log so that MTS could enlist the DB provider in the transaction making that rollback easier.
Move your log file into a database table and you will be able to rollback everything except the email being sent. - Jeff Marler B-)

 

[Deadline]

Thank you Jeff...
That helped...


Thank you very much.

RR