My recordset in VB6 is declared with a dynamic cursor. I can moveforard and to the begining, but it won't allow me to moveprevious.I'm not already at the BOF. What am I doing wrong?
Printable View
My recordset in VB6 is declared with a dynamic cursor. I can moveforard and to the begining, but it won't allow me to moveprevious.I'm not already at the BOF. What am I doing wrong?
whats your code look like?
I don't that MovePrevious is suported by dynamic type recordsets
If the Recordset object does not support either bookmarks or backward cursor movement, the MovePrevious method will generate an error.
This is assuming you are using ADO.
If you are using DOA, the manual says:
You can't use the MoveFirst, MoveLast, and MovePrevious methods on a forward-only–type CdbRecordset object.
And for RDO,
When using a forward-only rdoResultset, the you can reposition the current row only by using the MoveNext method. You cannot use the MoveLast, MovePrevious, MoveFirst, or Move method, or the PercentPosition or AbsolutePosition property, to reposition the current row pointer. If you use one of the prohibited Move methods on a forward-only result set, your code will trip an ODBC "Fetch type out of range" error.
Basically they all say the same thing. You have opened your recordset as a forward only cursor.
Regards
Paul Lewis