Dynamic Query not returning RecordCount

[abdullauthan]

I am using a Stored Procedure with Dynamic SQL Statements in SQL Server. If try to retrieve records using the Stored Procedure in VB (ADO Command & Recordset combination), there are no records retrieved. However if I extract the result to a MSHFlexGrid
(Set MSHFlexGrid1.DataSource=rstTest)
I can get the results. Still the RecordCount property of the rescordset is -1. I can get the results in SQL Query Analyzer also. Any help on this?

 

[RACaluste]

By default, your recordset cursorlocation is adUseServer and your recordset cursortype is adOpenForwardOnly. This will return a -1 in the RecordCount Property. Set the cursorlocation to adUseClient or change the cursortype to adOpenStatic or better.