how to implement Transaction

Results 1 to 2 of 2

Thread: how to implement Transaction

  1. #1
    Join Date
    Dec 1969

    Default how to implement Transaction

    Hi all,<BR><BR>i have to run a page which will do the following tasks<BR><BR>1.update balance in ACCOUNTS table.<BR>2.update balance of the 2nd user in ACCOUNTS table again.<BR>3.update EMAILSENDS Table.<BR>4.Send emails.<BR>5.update HISTORY table<BR><BR>and all of the above 5 steps have to be executed inside a loop which can urn upto 200 times.<BR>Can i use the begintransaction and committrans methods so that either all the changes take place or none.<BR>Where should i have to place the BeginTrans and CommitTrans methods.<BR>Please reply ASAP.<BR>Thanks a lot.<BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: how to implement Transaction

    begintrans before you start operating against the DB, commit when you finish.<BR><BR>logically enough.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts