ADO CursorLocation Property
 Complete Connection Object Reference
The CursorLocation property sets or returns a long value that indicates the location of the cursor service.
It can be set to one of the CursorLocationEnum
values. Default value is AdUseServer.
A cursor is used to:
- control record navigation
- control the visibility of changes in the database
- control the updatability of data
Note: A Recordset object inherits this setting from the associated
Connection object.
Note: This property is read-only on an open Recordset object, and read/write on a Connection
object or
on a closed Recordset object.
Syntax
objConnection.CursorLocation
objRecordset.CursorLocation
|
Example
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("northwind.mdb"))
set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT * FROM Customers"
rs.CursorLocation=adUseClient
rs.CursorType=adOpenStatic
rs.LockType=adLockBatchOptimistic
rs.Open sql,conn
rs.Close
conn.Close
%>
|
CursorLocationEnum Values
| Constant |
Value |
Description |
| adUseNone |
1 |
OBSOLETE (appears only for backward compatibility). Does not use cursor
services |
| adUseServer |
2 |
Default. Uses a server-side cursor |
| adUseClient |
3 |
Uses a client-side cursor supplied by a local cursor library. For backward compatibility,
the synonym adUseClientBatch is also supported |
Complete Connection Object Reference
 |
 |
 |
 |
|
The Ektron Intranet
lets you do everything you need to do on your corporate intranet and everything you want to do... all with just one application.
What can you do with the Ektron Intranet? |
 |
Navigate through content, documents, assets, colleagues and workgroups quickly and intuitively with enterprise search |
 |
Communicate with friends and colleagues with forums, message boards and corporate blogging using the new Social Networking Platform |
|
Utilize the extensive out-of-the box features or customize your site through Ektron CMS400.NET's open architecture |
 |
Promote collaboration in your organization through project workspaces where others can efficiently find information and work together |
 |
Author/edit content, manage navigation, menus, audit trails, workflow and approvals with the best in breed Content Management |
|
|
|
|
See why there are 20,000+ Ektron integrations worldwide.
|
|
 |
TAKE THE VIDEO TOUR |
 |
or download a FREE TRIAL today. |
|
HOME
Printer friendly page
