Recordset and CursorType

[loudandclear]

Hi,

I am trying to return a recordset that will support bookmarks so I can use the paging properties (AbsolutePage, ...) But all can manage to get is a forwardonly cursor.

Here is the code:

Set adoRecSet = CreateObject("ADODB.RecordSet&quot
adoRecSet.CursorType = 3
adoRecSet.Open strSQL, adoConn

After the open, the cursortype is always back to 0 (forwardonly) no matter what value I give to it before.

The connection string is using an oledb for sql server provider.

Could someone please help ?

Thanks,

Chris

 

[rac2]

I think the problem may be that there are a few more arguments used by adoRecSet.Open() than you have listed, and therefore the default value is used.
Try adding the third argument to your call.

Set adoRecSet = CreateObject("ADODB.RecordSet")        
adoRecSet.Open strSQL, adoConn, 3

There are five arguments for the Open method.
source
connection
cursor type
lock type
options