ADO CursorLocation Property
 Complete Recordset 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 Recordset Object Reference
 |
W3Schools' Online Certification Program
The perfect solution for professionals who need to balance work, family, and career building.
More than 4000 certificates already issued!
|
The HTML Certificate documents your knowledge of HTML, XHTML, and CSS.
The JavaScript Certificate documents your knowledge of JavaScript and HTML DOM.
The XML Certificate documents your knowledge of XML, XML DOM and XSLT.
The ASP Certificate documents your knowledge of ASP, SQL, and ADO.
The PHP Certificate documents your knowledge of PHP and SQL (MySQL).
| 
