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











PROPERTY:  DataControl::ReadyState

adcReadStateEnum = datacontrolobject.ReadyState

The ReadyState property returns one of the adcReadyStateEnum constants that indicates the current status of retrieving data from the data source and placing that data into the Recordset object associated with the DataControl object.

You can use the onReadyStateChange event to monitor the progress of the data retrieval.

adcReadyStateEnum Constants

Constant Value Description
adcReadyStateComplete 4 All data has been retrieved and stored in the Recordset, or an error has aborted the query, or the Recordset is not initialized
adcReadyStateInteractive 3 Recordset is currently receiving data
adcReadyStateLoaded 2 The query is executing but no data has been fetched

 
If an error occurs during the execution of the query and the operation is aborted, adcReadyStateComplete will be returned by the ReadyState property.

Code (VBScript):
If objDataControl.ReadyState = adcReadyStateLoaded Then
   MsgBox "Currently Executing Query", vbOK
End If

 


Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information