Board index » delphi » Transaction,Commit and Rollback

Alex Kon

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Transaction,Commit and Rollback

Could anyone show me an example or website how to apply these

Begin Transaction
Commit Transaction; and
Rollback Transaction

in Delphi and SQL7.

Thanks in advance.

Regards,
Alex Kong

 
Bulent Ozka

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Transaction,Commit and Rollback


If you are using TDatabase ,

procedure Customer.CommitClick(Sender: TObject);
begin
   TDatabase1.StartTransaction;
   try
      TQuery1.ApplyUpdates;
      TDatabase1.Commit;
    except
      TDatabase1.Rollback;
       raise;
    end;
  TQuery1.CommitUpdates;
end;

Bulent Ozkan

Quote
Alex Kong <mlar...@po.jaring.my> wrote in message

news:8mlqg5$8ev2@bornews.borland.com...
Quote
> Could anyone show me an example or website how to apply these

> Begin Transaction
> Commit Transaction; and
> Rollback Transaction

> in Delphi and SQL7.

> Thanks in advance.

> Regards,
> Alex Kong

Other Threads

1. Transaction Methods in Interbase using Delphi 3.0 -Problems in commit-rollback methods

2. Start / Commit / Rollback Transactions

3. Explicit Transaction (Commit/Rollback)

4. Transactions Rollback Commit question

5. Transaction.Commit vs. using SQL to call COMMIT

6. The rollback transaction request has no corresponding BEGIN TRANSACTION

7. The rollback transaction request has no corresponding BEGIN TRANSACTION

8. tried to commit or rollback a transaction without first beginning a transaction"

9. Please help with Interbase and Commit/Rollback

10. Delphi 3 DBError can not commit or rollback before begintrans