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:  Recordset::ActiveCommand
Set commandobject = recordsetobject. ActiveCommand

The ActiveCommand property returns a variant that contains the Command object used to create the Recordset object.

This is a convenient way to find the associated Command object even if you only have the resultant Recordset. However, if the Recordset was not created by a Command object, then a Null object is returned. You can use this property even after the Recordset has been closed.

As shown in this example, you can return the value for individual properties of the Command object:

Code (VBScript):
strCmdText = objRecordset.ActiveCommand.CommandText
strCmdType = objRecordset.ActiveCommand.CommandType

 


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