Re: Problem with insert statement in Delphi

[Dermawan Lobion]

I have the same problem with inserting into MySQL from Delphi. I also use ADO components, Tomasz.
But maybe the problem is not exactly the same. Everytime I try to insert from the running application, I always get an EAccessViolation in module "msado15.dll". No probelm with the select queries though.
I have found in a link (http://forums.devshed.com/newreply.php?do=newreply&p=1304405) that doing:

ADOConnection1.Connected := False;
ADOConnection1.Connected := True;

everytime before inserting solves the problem. But, the problem is I'm using transaction like Tomasz's code. And if I restarted the connection, the transaction wouldn't work. What can I do to solve this problem? Thanx in advance.

Best regards,
Dermawan