Forum Discussion

ElizabethO's avatar
ElizabethO
Occasional Contributor
5 days ago

'ADO' is not defined error - TC v15.79

Each time I run a test that runs a python script I get the 'ADO is not defined' error, then I restart my TC and run the test again and then it works, meaning if I have 10 test cases that have python ...
rraghvani's avatar
rraghvani
Icon for Champion Level 3 rankChampion Level 3
5 days ago

Are you able to provide example code of it failing?

  • ElizabethO's avatar
    ElizabethO
    Occasional Contributor
    3 days ago

    def Get_Available_Customer_Details_Not_Linked_To_Asset() :
      
      customer= executeQuery("SELECT TOP 1 [Number], [Name] FROM [dbo].[Asset] WHERE [Id] NOT IN (SELECT DISTINCT [AssetId] FROM [dbo].[Asset] WHERE [AssetId] IS NOT NULL)");
      
      for customer in customers :
          AssetNumber = customer["Number"]

          AssetName = safe["Name"]

          AssetDetails = f"{AssetNumber} {AssetName}"

          return assetDetails
      
      Log.Error("No available asset exists!");

    • rraghvani's avatar
      rraghvani
      Icon for Champion Level 3 rankChampion Level 3
      3 days ago

      I don't see ADO usage, in the coding that you have provided? There should be something like,

      def TestProc():
  Cmd = ADO.CreateADOCommand()
  Cmd.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + \
  'Data Source=C:\\Users\\Public\\Documents\\TestComplete 14 Samples\\Desktop\\Checkpoints\\XML\\DataGridViewSample\\OrdersDB.mdb'
  Cmd.CommandText = 'SELECT * FROM orders WHERE orders.[state] = 2'
  # etc

       

      • ElizabethO's avatar
        ElizabethO
        Occasional Contributor
        3 days ago
        def executeQuery(queryString, queryParameterListOfDictionary = []) :
  query = ADO.CreateADOQuery();
  
  try :    
    query.ConnectionString = getDbConnectionString();
    
    query.SQL = queryString;
    # Map query parameters and values.
    for queryParameter in queryParameterListOfDictionary :
      for key, value in queryParameter.items() :
        query.Parameters.ParamByName(key).Value = value;
  
    query.Open();
    results = convertQueryToListOfDictionaries(query);
    
    return results;
    
  except Exception as e:    
    Log.Error(str(e));
    
  finally :
    closeDbConnection(query);

        Here it is