How to open recordset properly ? (use .Execute method)

[digarton]

The problem is:<br>I'm working with SQL stored procedures and use Command objects and Execute method to open recordsets. But they don't support such properties as PageCount, RecordCount, etc. How can I fix that not using rs.Open method? <br>Thanx.

 

[toddB]

it all depends on how you open the recordset on whether you will get recordcount and other properties.<br><br><br>sSQL = What ever your stored procedure is called<br><br>rs.Open sSql, Conn object, (adOpenDynamic, adOpenStatic, adOpenForwardOnly, adOpenKeyset, adOpenUnspecified)<br><br>it defaults to ForwardOnly, for your record count and page count try adOpenStatic.