I have a problem when I attempt rollback transaction using tMyTable, follows code in delphi:
con.StartTransaction;
try
qConsulta.First;
while not qConsulta.Eof do begin
//My commands
end;
con.commit
except
con.rollback
end;
Well, if I call rollback thought a button, it works perfect, but if I close form it commit transaction...When I use tMycommand work perfect like code bellow:
cmd.AutoCommit:=False;
cmd.SQL.Text:='start transaction';
cmd.Execute();
Did you note that I setup explicit autocommit:=false?? How can I do it using tMytable??
Rollback Transaction
We couldn't reproduce the problem.
Please send us (mydac*crlab*com) a complete small sample to demonstrate it and include script to create and fill table.
Also supply us following information
- Exact version of Delphi, C++ Builder or Kylix
- Exact version of MyDAC. You can see it in About sheet of TMyConnection Editor
- Exact version of MySQL server and MySQL client.
You can see it in Info sheet of TMyConnection Editor
Please send us (mydac*crlab*com) a complete small sample to demonstrate it and include script to create and fill table.
Also supply us following information
- Exact version of Delphi, C++ Builder or Kylix
- Exact version of MyDAC. You can see it in About sheet of TMyConnection Editor
- Exact version of MySQL server and MySQL client.
You can see it in Info sheet of TMyConnection Editor