Forum Discussion

elesniewski's avatar
elesniewski
Occasional Contributor
7 years ago

TestComplete does not wait for SQL query results before performing next step

I have TestComplete step that queries SQL server to run a procedure.  I have scripted the query to monitor the status of the procedure and return when complete.  I have run this successfully in TestC...
elesniewski's avatar
elesniewski
Occasional Contributor
7 years ago

The test is broken again, at this step.

I setup the code as suggested in the article.

It worked fine the first few times, but today, it is showing the same bug.

The test does not wait for SQL query results before performing the next step.

 

Is there and dummy output result that I can setup, even though the stored procedure does not take any parameters?  I would like to try and see if this will force TestComplete to wait for the stored procedure to finish before moving on to the next step?  Something like:

  // Adding a return parameter
  SProc.Parameters.AddParameter();
  SProc.Parameters.Items(0).name = "RETURN_VALUE";
  SProc.Parameters.Items(0).DataType = adInteger;
  SProc.Parameters.Items(0).Direction = adParamReturnValue;  
  SProc.Parameters.Items(0).Value = null;

...

Log.Message("Result: " + SProc.Parameters.Items(0).Value);