Shulou(Shulou.com)06/02 Report--

This article mainly explains "how to understand ADO steps". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to understand ADO steps".

Returns when an ADO step is requested on the server side. This is because the CursorType in ActiveX Data Objects (ADO) 2.0 is adOpenForwardonly or adOpenDynamic. If it is an ADO step, it only occurs when cursortype is adOpenForwardonly.

The provider may not support some CursorTypes. When the CursorType you choose is not supported, the provider will choose the CursorType that is closest to your request. Please refer to your provider's documentation. In addition, note that not all combinations of LockType and CursorType work at the same time. Changing the LockType will force a change in the ADO step. Be sure to use debugging to check the value of CursorType.

The record number may change in a dynamic cursor. The cursor for Forward only cannot return an ADO step. The solution uses adOpenKeyset (= 1) or adOpenStatic (= 3) as server-side cursors or client-side cursors. The client only uses adOpenStatic as the CursorTypes, no matter which CursorType you choose.

The form of state is the ADO step of repeating behavior for more information determined by the design:

Openastandard.exeprojectinVisualBasic.FromtheProjectmenu,chooseReferences.SelecteithertheMicrosoftActiveDataObject1.5LibraryortheMicrosoftActiveDataObject2.0Library. Pastethefollowingcodeintheformcodewindow: OptionExplicit DimrsAsADODB.Recordset PrivateSubForm_Load () 'setuprs Setrs=NewADODB.Recordset rs.CursorLocation=adUseServer rs.Open "SelectProductIDfromproducts", & _ "Provider=Microsoft.Jet.OLEDB.3.51 "&" DataSource=d:\ vb5_win95\ nwind.mdb ", _ adOpenDynamic,adLockUnspecified Debug.Printrs.RecordCount EndSub thank you for your reading. The above is the content of" how to understand the ADO steps ". After the study of this article, I believe you have a deeper understanding of how to understand the ADO steps, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.