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
 |
|
Get Your Diploma!
W3Schools' Online Certification Program is the perfect solution for busy
professionals who need to balance work, family, and career building.
The HTML Certificate is for developers who want to document their knowledge of HTML, XHTML, and CSS.
The JavaScript Certificate is for developers who want to document their knowledge of JavaScript and the HTML DOM.
The XML Certificate is for developers who want to document their knowledge of XML, XML DOM and XSLT.
The ASP Certificate is for developers who want to document their knowledge of ASP, SQL, and ADO.
The PHP Certificate is for developers who want to document their knowledge of PHP and SQL (MySQL).
|
|
