transactions - with midas and mydac

CFaiga · Post by **CFaiga** » Sat 24 Jun 2006 09:10

Hi

How does one do transacations with mydac, mysql and midas
while calling an number of Stored procedures

I am using
-Delphi 7 with
- MySql ver5.0.21,
- Midas and
- Mydac

thanks

Antaeus · Post by **Antaeus** » Mon 26 Jun 2006 14:24

To control transactions you should use StartTransaction, Commit, Rollback methods of TMyConnection component. You can start transaction before calling your stored procedure and commit or cancel it after the procedure finishes. Depending on your task two or more procedures can be called in a single transaction.