mvlaicov
Occasional Contributor
Joined 9 years ago
User Profile
User Widgets
Contributions
Re: How to use Update and delete SQL statements using ADO
procedure CleanDB; var AConnection : OleVariant; SQLQry : string; begin //Create new connection object AConnection := ADO.CreateADOQuery; //Run Scripts SQLQry := 'SELECT * from Provinces;'; //specify the connection string AConnection.connectionstring := HIDDEN; //disable prompt for login //AConnection.LoginPrompt := false; AConnection.SQL := SQLQry; AConnection.Open; AConnection.Close; end; We are running a simple select statement in here that works. But I want to be able to run a series of inserts or possibly delete statements on the database.4KViews0likes6CommentsHow to use Update and delete SQL statements using ADO
I am attempting to "Clean" mySQL database before I start my functional test. I am hung up on executing insert and delete SQL statements on the database. I am able to connect and run queries through the ado calls but I cannot figure out how to run insert or delete statements. Can someone post a possible example for me?Solved4.1KViews0likes8Comments