-
How can you open a recordset so you can use MovePrevious and MoveLast on the recordset?
I have tried adOpenDynamic, adOpenKeySet, and adOpenStatic. When I try to MovePrevious it say, "Run-time error 3219. The operation requested by the application is not allowed in this context" and when I try MoveLast it say, "The rowset does not support fetching backwards"
I am using mySQL. I open the connection without using a DSN.
-
I solved the problem. If anyone wants to know the solution here it is.
To use MoveLast and MovePrevious with and ADO connection and mySQL you must use object.CursorLocation = adUseClient. Then to two aforementioned cursor movements work.
This has to be declared before an connection is opened.
