Forum Discussion

mvlaicov's avatar
mvlaicov
Occasional Contributor
8 years ago

How 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?

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    8 years ago

    Could you post the code that you are using for the queries you can run? As far as i know, it SHOULD be very similar code.

    • mvlaicov's avatar
      mvlaicov
      Occasional Contributor
      8 years ago
      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.

      • tristaanogre's avatar
        tristaanogre
        Esteemed Contributor
        8 years ago

        What happens when you replace

         

        SQLQry := 'SELECT * from Provinces;';

         with 

         

        SQLQry := 'DELETE * from Provinces;';

        It SHOULD be pretty straight forward...  Are there error messages that come up?