Compare two DBTables objects

Hi Nancy,






Currently, the DBTable Checkpoint feature of TestComplete does not allow saving baseline data without any records. I have registered your request as a suggestion in our database.






In the meantime, you can use the ADO extension to check whether there are any records recorded by a request.

function testADORequest()


{


  var Cmd = ADO.CreateADOCommand();


  Cmd.ConnectionString = "Driver={SQL Server Native Client 10.0};Server=myServer;Database=myDatabase; Uid=myUsername;Pwd=myPassword;";


  Cmd.CommandText = "SELECT * FROM USERS WHERE PEN_NAME = 'Nancy'";


  Cmd.CommandType = cmdText;






  var RecSet = Cmd.Execute();


  if (RecSet.EOF == true) {


    Log.Message("The recordset is empty");


  }


  else {


    Log.Message("The recordset contains items");


  }


}