R
Richard Ohl
Hi,
I need some help with Querytables. I've written some code to put the results
of a query (stored procedure, called with different parameters) into an
excel sheet.
Now, that works fine, and my querytableobject.ResultRange.Rows.Count gives
the correct number of results (count = 4 if 4 results are displayed).
However, if the resultset is empty, the count is 2.
What could I check to get the correct number of results? Running the same
query in Query Analyser or in Microsoft Query displays the (correct) empty
resultset, and nothing more. NOCOUNT is set to ON in the procedure.
I'd greatly appreciate any tipps.
Kind regards,
Richard
I need some help with Querytables. I've written some code to put the results
of a query (stored procedure, called with different parameters) into an
excel sheet.
Now, that works fine, and my querytableobject.ResultRange.Rows.Count gives
the correct number of results (count = 4 if 4 results are displayed).
However, if the resultset is empty, the count is 2.
What could I check to get the correct number of results? Running the same
query in Query Analyser or in Microsoft Query displays the (correct) empty
resultset, and nothing more. NOCOUNT is set to ON in the procedure.
I'd greatly appreciate any tipps.
Kind regards,
Richard