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
Command State Property
Connection State Property
Record State Property
Streamt State Property
PROPERTY: Recordset::State
ObjectStateEnum =
recordsetobject.
State
The
State
property returns a long value that is the sum of one or more
ObjectStateEnum
constants. These constants describe if the
Recordset
object is open, closed, or executing an asynchronous operation.
You can call the
State
property at any time. The default value is
adStateClosed
.
ObjectStateEnum Constants
Constant
Value
Description
adStateClosed
0
Object is closed
adStateConnecting
2
Object is connecting
adStateExecuting
4
Object is executing
adStateFetching
8
Object is fetching
adStateOpen
1
Object is open
Code (VBScript):
If rsGuruChants.
State
= adStateFetching Then
MsgBox "Recordset is fetching records", vbOK
End If
Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information
