The Cursor Location Property

This property allows you to specify whether the server-side cursor engine or the client-side cursor engine manages the records in the recordset. A cursor is the underlying object that manages the data in the recordset. Certain operations require the cursor engine to be on one side or the other. This is explored in more detail in the examples section.

This property must be set before the recordset is opened. If you do not specify a cursor location, the default is server-side. You can set this property to one of the two CursorLocationEnum values, either adUseClient or adUseServer. The following code sample demonstrates setting the cursor location to client-side:

rsData.CursorLocation = adUseClient

0 0

Post a comment