MySQL Forums
Forum List  »  Delphi

Re: Problem with insert statement in Delphi
Posted by: Dermawan Lobion
Date: July 18, 2006 08:39PM

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 ( 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,

Options: ReplyQuote

Written By
Re: Problem with insert statement in Delphi
July 18, 2006 08:39PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.