Rowset does not support fetching backward.

[beaniebear]

I'm having a problem when returning a recordset from a SQL server stored procedure. I have set the cursor and lock properties of the recordset but I get an error when I use .movelast etc.

Any help would be greatly appreciated.

Thanks.

 

[krisbrixon]

It might be helpful if you mentioned what you set the properties to?

 

[FesterSXS]

try setting the cursorType to 'adOpenStatic' Tony

http://www.phoenix-paints.co.uk/portfolio

 

[beaniebear]

rstRecordset.CursorType=3
rstRecordset.LockType=3

 

[beaniebear]

I have set the cursor to static. This works when the stored procedure contains one query. On my SP which contains 3 querries, one of which runs depending on what parameters have been passed, I still cannot use movelast e
tc

I get the error 'Rowset does not support fetching backward'

Any ideas?