Unanswered: rowset doen not support scrolling backward
I am using VB6.0 and Sql server 2000 for developing an application. My problem is i have written a stored proc for retreiving records from database and i am executing it from Vb. When i do
set recordset= cmd.execute and count the recorcount.
it gives me recordcount as -1 and when i use rs .find it says "rowset doen not support scrolling backward ".
I am using cursor and lock type as
rs.LockType = adLockBatchOptimistic
rs.CursorType = adOpenKeyset