When/why does getquery append a blank row at end of rowset?
I have a query that when I use GetQuery to create the empty query object and then use the object to open an existing query using the OPEN method. I used the RunToRowSet method to return the results to a rowset. RowCount is used to get the total number of rows returned. The row count is one more than the number of rows returned when running the the query through Query Manager and one more than running the query SQL using SQLserver Object Explorer.
This extra row at the end of the rowset contains empty or zero values wrapped in double quotes and separated by comma delimiter. This formatting is identical to each of the prior 1000+ rows in the rowset.