Devart Forums

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

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.