Quick References
ADO
ASP
CSS2
HTML
JavaScript
Jet SQL
VBScript
WML
WMLScript
WSH
XHTML
XML DOM
XSLT
Features
Knowledge Base
Tutorials
Partners
ZVON.ORG
XML
Planet Source Code
VisualBuilder
Web Design
Your HTML Source
XML/XSLT Forums
ASPAlliance
Scripts
Programmers Heaven
Tek-Tips Forums
Developer Fusion
Code Project
CursorType Property
Recordset Object
Connection Object
Connection Execute Method
PROPERTY: Recordset::CursorLocation
CursorLocationEnum =
recordsetobject.
CursorLocation
recordsetobject.
CursorLocation
= CursorLocationEnum
The
CursorLocation
property sets or returns one of the
CursorLocationEnum
constants that specifies the location of the cursor library. In reality, there are only two choices, client-side or server-side. Typically, client-side cursors are more versatile. However, the default is to the server-side.
You cannot change the cursor library for a
Recordset
while it is open.
CursorLocationEnum Constants
Constant
Value
Description
adUseClient
3
Use client-side cursor supplied by the local cursor library
adUseClientBatch
3
Obsolete, same as
adUseClient
adUseNone
1
Obsolete, no cursor service
adUseServer
2
Default, use the cursor supplied by provider or database
Code (VBScript):
Set objRecordset = Server.CreateObject("ADODB.Recordset")
Set objRecordset.ActiveConnection = strConnection
objRecordset.
CursorLocation
= adUseClient
objRecordset.CursorType = adOpenDynamic
...
objRecordset.Open "ChantList", , , , adCmdTable
Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information
