Forum Discussion

NT's avatar
NT
Contributor
10 years ago

How to refresh a DB Table Variable in a Loop

Hi,   I would like to continue to a second KeywordTests base on a field that is update in a Database.   So in terms of word.   I execute Test1 and would like to execute Test2 only if the Field ...
  • cunderw's avatar
    cunderw
    10 years ago

    Without seeing your setup in person I would do something like this.

     

    At the end of  Test1 Run this script (obviously filling in the details).

     

    function checkStatut() {
  var dbConnection,
      record,
      statut;
  
  dbConnection = ADO.CreateADOConnection();
  dbConnection.ConnectionString = "connectionString"
  dbConnection.LoginPrompt = false;
  dbConnection.Open()
  
  record = dbConnection.Execute_("sql query");
  statut = record.Fields("Statut").Value;
  
  if (statut == "<P>")
	KeywordTests.Test2.Run(); //assuming Test2 is a keyword test
    
  
}
  • NT's avatar
    NT
    10 years ago
    thanks it work fine, but now if the Statut become at value P only after a certain time so it means that I need to refresh the information of the statut by reading the information in the database until it becomes at value P. It is a delay treatment. is it possible to use a Loop to wait until the statut become at value P ? thanks a lot for your help !!!
  • cunderw's avatar
    cunderw
    10 years ago

    Sure try something like this:

     

    function checkStatut() {
  var dbConnection,
      record,
      statut;
  
  dbConnection = ADO.CreateADOConnection();
  dbConnection.ConnectionString = "connectionString"
  dbConnection.LoginPrompt = false;
  dbConnection.Open()
  
  while (statut != "<P>") {
    record = dbConnection.Execute_("sql query");
    statut = record.Fields("Statut").Value;
  
    if (statut == "<P>")
   	  KeywordTests.Test2.Run(); //assuming Test2 is a keyword test
  }
}
NT's avatar
NT
Contributor
Hi cunderw, thanks for your aswer ! I decided to use ADO connection in a script but I still can't refresh the information in feield from the Database. here is the script can you help me to find what is wrong please ? function TestProc() { var Qry; var identifiant = KeywordTests.Cas1.Variables.IdentifiantVar1; var NewValue; // Create a query Qry = ADO.CreateADOQuery(); // Specify the connection string Qry.ConnectionString = "Provider=OraOLEDB.Oracle.1;Password=PW;Persist Security Info=True;User ID=User;Data Source=Database"; // Specify the SQL expression Qry.SQL = "SELECT etd_val_ident_execu_trait, etd_no_execu_xai, tdi_no_ident, pca_no_proje_calcu, etd_descr, etd_date_debut_execu, etd_date_fin_execu, std_statu_trait, etd_pourc_avanc FROM cpf_execu_trait_diffe WHERE tdi_no_ident = 3 AND TO_CHAR(etd_date_debut_execu, 'YYYY-MM-DD') = TO_CHAR(SYSDATE, 'YYYY-MM-DD') ORDER BY etd_date_debut_execu DESC"; // Execute the query Qry.Open(); // Process results and Loop while the std_statu_trait field is not equal to "P" // (first it is equal to EC and after a certain time, it change to P // and this is when this happen that I would like to continue my test ) ... do // Here I try to refresh the field std_statu_trait to look if it has change to P // but never refresh the field it always keep the same value of the first read. NewValue = (Qry.FieldByName("std_statu_trait").Value); while (Qry.FieldByName("std_statu_trait").Value != "P"); { Log.Message(Qry.FieldByName("pca_no_proje_calcu").Value); Log.Message(Qry.FieldByName("std_statu_trait").Value + Qry.FieldByName("pca_no_proje_calcu").Value); } // Closes the query Log.Message("Statut égal P"); Log.Message(Qry.FieldByName("std_statu_trait").Value + Qry.FieldByName("pca_no_proje_calcu").Value); Qry.Close(); } Best regards,
cunderw's avatar
cunderw
Community Hero
10 years ago

Without seeing your setup in person I would do something like this.

 

At the end of  Test1 Run this script (obviously filling in the details).

 

function checkStatut() {
  var dbConnection,
      record,
      statut;
  
  dbConnection = ADO.CreateADOConnection();
  dbConnection.ConnectionString = "connectionString"
  dbConnection.LoginPrompt = false;
  dbConnection.Open()
  
  record = dbConnection.Execute_("sql query");
  statut = record.Fields("Statut").Value;
  
  if (statut == "<P>")
	KeywordTests.Test2.Run(); //assuming Test2 is a keyword test

  
}
  • NT's avatar
    NT
    Contributor
    10 years ago
    thanks it work fine, but now if the Statut become at value P only after a certain time so it means that I need to refresh the information of the statut by reading the information in the database until it becomes at value P. It is a delay treatment. is it possible to use a Loop to wait until the statut become at value P ? thanks a lot for your help !!!
    • cunderw's avatar
      cunderw
      Community Hero
      10 years ago

      Sure try something like this:

       

      function checkStatut() {
  var dbConnection,
      record,
      statut;
  
  dbConnection = ADO.CreateADOConnection();
  dbConnection.ConnectionString = "connectionString"
  dbConnection.LoginPrompt = false;
  dbConnection.Open()
  
  while (statut != "<P>") {
    record = dbConnection.Execute_("sql query");
    statut = record.Fields("Statut").Value;
  
    if (statut == "<P>")
   	  KeywordTests.Test2.Run(); //assuming Test2 is a keyword test
  }
}
      • NT's avatar
        NT
        Contributor
        10 years ago
        Perfect !! thanks again :)