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?

 

[BobWman]

Try using a client side cursor.

 

[Brewman76]

The recordcount property will return -1 if you are using a forward only cursor (the default cursor I believe). Depending on your data source, a dynamic cursor will also return -1. The value of -1 however does not mean your data did not get retreived, it just means that ADO was not able to determine how many records were returned.

Adam

 

[Guest_imported]

You have to set the CursorLocation property to "adUseClient"
Then only it will return the record count. The default is Server side.

 

[CCLINT]

First of all, try moving to the last record.