 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
VB Forum / Database Access / January 2007adMoveForwardOnly question
Hi, If one is using a server side cursor from a provider that only implements an adMoveForwardOnly cursor, what exactly are the movement limitations, and what are the expected results if you violate them? IE, I know you can't do recordset.MovePrevious, but can you do recordSet.MoveFirst if you are already on a record greater than 1? If not and you attempt it, should it fail gracefully with a nice error? I'm trying to create a set of tests for an ODBC driver. Thank You > Hi, > [quoted text clipped - 7 lines] > If not and you attempt it, should it fail gracefully with a nice > error? I'm trying to create a set of tests for an ODBC driver. Forward only means exactly that, MoveNext is the only valid move. Calling an invalid method throws an error. Suggestion: base your tests on behavior of an established driver. -Mark > Thank You Hmm, well MoveLast is still moving in the forward right? Would that not be supported? I think this is a sensible suggestion, and would be very helpful to baseline my code. Would you happen to know what database providers offer only a MoveForwardOnly client cursor? Thanks Eric >Forward only means exactly that, MoveNext is the only valid move. Calling an >invalid method throws an error. [quoted text clipped - 4 lines] > >> Thank You > Hmm, well MoveLast is still moving in the forward right? Would that > not be supported? > > I think this is a sensible suggestion, and would be very helpful to > baseline my code. Would you happen to know what database providers > offer only a MoveForwardOnly client cursor? Not certain about MoveLast. As for forward-only cursor support, SQL Server does for sure, I assume Jet does as well. With SQL, just open a connection and call the Execute method to create a forward-only, read-only recordset, e.g., Set rs = cn.Execute("SELECT * FROM ...") -Mark > Thanks > Eric [quoted text clipped - 8 lines] >> >>> Thank You |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.