ADODB Recordset MoveFirst error 1

[graabein]

Hi, I get an error trying to MoveFirst on a Recordset. I've been debugging but I can't figure it out... Here's what I've got:

Set cmd = New ADODB.Command
With cmd
  .ActiveConnection = myConn
  .CommandType = adCmdStoredProc
  .CommandText = "usp_GetDayList
  'Parameters...
End With

Set rs = New ADODB.Recordset
rs.Open cmd, , adOpenDynamic, adLockReadOnly
If rs.State = adStateOpen Then
  Debug.Print "rs.CursorType: " & rs.CursorType
  rs.MoveNext
  rs.MoveNext
  rs.MoveFirst
  'Error!!

That code gives me cursor type adForwardOnly and an error at rs.MoveFirst!!?? Cursor location is server side. I know the returned recordset has more than 3 rows...



graabein

 

[jadams0173]

There is some good infor on locks and cursors in this thread thread222-1363106

For some reason your cursor is being manipulated to forward only and forward only cursors can't go back.

I had a similar problem in the thread posted above. The good stuff in towards the end of the thread.

 

[graabein]

Thanks for the link. I've changed my routine to use dynamic client side cursor and rs.MoveFirst works as a charm!


graabein

 

[SBerthold]

er, something doesn't sound right.
Are you expecting to update the DB table?

Check the following:

Debug.? rs.CursorType

Debug.? rs.CursorLocation

Debug.? rs.LockType

 

[JoeAtWork]

It may be that a recordset can not be updateable if it is created from a stored procedure.

ADO usually changes properties such as cursor type when it thinks your setting is not possible (like changing adOpenDynamic to adForwardOnly).

Joe Schwarz
Custom Software Developer

http://www.plandev.net