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

This does appear to work well.  I will update as solution after a few days of testing.  Thanks.

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);